topic Re: Unable to get the row count in Talend Studio

Unable to get the row count

Anonymous — Sat, 16 Nov 2024 06:36:58 GMT

Hi,

I am new in the Talend and trying below scenario.

Scenario:

Read CSV file and after reading the file print number of lines in the file. Output in console. Should be done in 3 components.

for this I am using below components:

tFileInputDelimited --> tFileRowCount --> tFileOutputDelimited

Output in console:

getting rows but no count at the end.

Can anyone help me to sort out this issue.

Thank you!

Re: Unable to get the row count

David_Beaty — Tue, 12 Feb 2019 12:26:51 GMT

Hi,

As you're reading in the file in the tFileInputDelimted component, after the output, you can get the row count by querying the NB_LINES component variable for either the input or output components , connect a tJava AFTER both with an "OnSubjobOK" and you should have access to it.

Re: Unable to get the row count

vapukov — Tue, 12 Feb 2019 12:28:40 GMT

tFileRowCount - independent component and really not needed in this chain

you just need add tJava (OnSubJobOk or OnComponentOk) with code:

System.out.println(((Integer)globalMap.get("tFileOutputDelimited_1_NB_LINE")));

same for tFileInputDelimited (good if used filter - count IN - count Out)

Re: Unable to get the row count

Anonymous — Wed, 13 Feb 2019 06:37:30 GMT

Thank you Guys! I got the number of lines in the console.