Forum Discussion

rajendraj's avatar
rajendraj
New Contributor II
5 years ago

Record Count in CSV

Is there an easier way to find the number of records in an incoming CSV? Want to log this information before processing the file. Appreciate the help but looking for a setting or simpler way to count the number.

2 Replies

  • cstewart's avatar
    cstewart
    Former Employee

    I suggest that you need to read the file, then use and Aggregate Snap with no Group, and for the count, use the COUNT function on a String e.g. “A”. This will give you the count of rows without incurring much overhead.