How to count files lines using NiFi

[#1]

Hi Everyone, I collect data files with NiFi using ListSFTP AND FetchSFTP processors. In these data files I have several different lines. I want to know if there is a processor that can allow me to count the number of lines in the files as I collect them to have a total number of lines. Someone can help me.

[#2]

You can use processor name CountText

Thank You.

[#3]

Hi @ckumar, Thanks for your help but I had used CountText but the problem is that I have csv files and I only see the number of files instead of counting the number of lines in the files.

[#4 · Accepted solution]

 I have used CSV file withCountText and it worked fine for me,  Upon success it will writes an attribute name "text.line.count" with number of lines as value, attaching sample csv file which I used to test and it has 6 lines. 

[#5]

if it's csv, use QueryRecordProcessor with csv reader

then just do SELECT COUNT(*) FROM FLOWFILE

[#6]

Hi @TimothySpann, What is the difference between CountText and QueryRecord. Can you detail the use of QueryRecord? Thanks

[#7]

CountText will count lines (\r\n).

QueryRecord will count # of records, even if it is two records on a line