Thanks for the reply.
If I use aggregate snap, it will change the structure of my data. I just wanted to check if my file(to be loaded) has records then load the entire file else exit the pipeline.
Is there a way to count records in a csv(without using Aggregate snap) which I would use in a Router. If the value>0 then load the file else exit the pipeline.
Kindly suggest.
File Reader Snap gives a “content-length” field, which when 0 means an empty file. You can use a Binary Router Snap to route the empty and non-empty files. Alternatively the CSV Parser Snap has an option to Ignore Empty data, which when enabled stops the execution.
For SQL Table, the SQL Server Select snap has an option to Ignore empty result, which when enabled stops execution
