How to know RowCount of a file

[abhi90]

I have a file with the below data.How to get the exact rowcount of the file i.e 13?
EMPNO,EMPNAME,DEPTNO
10,A,1
11,B,2
12,C,3
13,D,4
14,E,1
15,F,1
16,G,2
17,H,3
18,I,4
19,J,2
20,K,3
21,L,1
22,M,2

[abhi90]

Hi Shong;
Can anyone help me out in this case?

[Anonymous]

Hi Abhi,



In above mention screenshot, the global variable "Number of Lines" of tfileinputdelimited components will give you exact row count of the file.

[abhi90]

Hi swabhosa;
Can you elaborate more on this below context?how to use it?

[Anonymous]

Howdy Abhi,
What is the dilemma?

[abhi90]

Hi dudedoe;
I didn't get you.can you elaborate me further?

[Anonymous]

Hi Abhi,

I have created a demo job to show exact row count of records from source file.

I have 100 records in my source file. Job design is simple as given below :- 




When you drag and drop the variable associated with tfileinputdelimited component "Number of Line(After)" in tjava component as show in below image :-




You will find that variable repository box (refer below image) 




My output is shown in below image :-




Hope everything is clear to you.

Regards
SB