topic Re: How to know RowCount of a file in Talend Studio

How to know RowCount of a file

abhi90 — Wed, 11 Jan 2017 14:07:04 GMT

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

Re: How to know RowCount of a file

abhi90 — Wed, 11 Jan 2017 14:12:29 GMT

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

Re: How to know RowCount of a file

Anonymous — Wed, 11 Jan 2017 15:04:01 GMT

Hi Abhi,

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

Re: How to know RowCount of a file

abhi90 — Wed, 11 Jan 2017 16:41:09 GMT

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

Re: How to know RowCount of a file

Anonymous — Wed, 11 Jan 2017 20:32:55 GMT

Howdy Abhi,
What is the dilemma?

Re: How to know RowCount of a file

abhi90 — Thu, 12 Jan 2017 09:28:30 GMT

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

Re: How to know RowCount of a file

Anonymous — Fri, 13 Jan 2017 10:48:48 GMT

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