topic Re: [resolved] Count Rows of CSV file in Talend Studio

[resolved] Count Rows of CSV file

Anonymous — Thu, 17 Dec 2015 21:17:33 GMT

Hello,
I need to count the numbers of rows in a CSV file (input file ) to use it later as a global variable.
How can I do that with talend and which composant should I use ?
I really do need help, I tried tFileRowCount and it doesn't work !

Re: [resolved] Count Rows of CSV file

Anonymous — Thu, 17 Dec 2015 23:04:21 GMT

To count the rows you have to read the file anyway. I suggest you use tFileInputDelimited with only one column and use the return value of the component NB_LINE.

Re: [resolved] Count Rows of CSV file

Anonymous — Fri, 18 Dec 2015 08:28:24 GMT

Hi,
Have you already checked component reference about TalendHelpCenter:tFileRowCount with scenario?

Best regards
Sabrina

Re: [resolved] Count Rows of CSV file

Anonymous — Fri, 18 Dec 2015 17:27:02 GMT

I solved the problem using tFileRowCount, thanks for your help

Re: [resolved] Count Rows of CSV file

Anonymous — Mon, 21 Dec 2015 07:57:01 GMT

Hi Boubou 00,
Thanks for your feedback and posting that you have resolved it.

Best regards
Sabrina

Re: [resolved] Count Rows of CSV file

Anonymous — Sun, 17 Apr 2016 17:21:55 GMT

@Boubou 00

could you please share how you resolved this issue using tFileRowCount??