topic Re: tFileRowCount Count Rows in Talend Studio

tFileRowCount Count Rows

Anonymous — Sat, 16 Nov 2024 14:26:18 GMT

Greetings,
How can I use this component? tFileRowCount, I can not find description anywhere.
How can I count rows in a file?
Thank You

Re: tFileRowCount Count Rows

Anonymous — Thu, 06 Mar 2008 17:12:18 GMT

you can do this

Re: tFileRowCount Count Rows

Anonymous — Thu, 06 Mar 2008 17:42:40 GMT

Thank you. I have also found that I can use tAggregateRow to count rows.

Re: tFileRowCount Count Rows

Anonymous — Thu, 06 Mar 2008 17:47:17 GMT

Actually you can also use the global variable of your file component

Re: tFileRowCount Count Rows

Anonymous — Thu, 06 Mar 2008 20:40:10 GMT

Global Variable returns zero records. I have to add a row count after all of the processing has been done. OATS_REPORT is the same file, and the data is being appended there. I don't know what I am doing wrong

Re: tFileRowCount Count Rows

Anonymous — Thu, 06 Mar 2008 23:02:52 GMT

If I understand your need, you want to know the number of lines in the file written by tFileOutputDelimited right after the tUnite. My advise is to use a tFlowMeter between tUnite and tFileOutputDelimited and to use its global variable NB_LINE.

Re: tFileRowCount Count Rows

Anonymous — Thu, 06 Mar 2008 23:06:20 GMT

Yes, you correctly understand what I want.
By some lucky coincidence I was able to arrive to the configuration that was able to give me what I wanted. I don't fully understand why it works, but it does.
Thank You

Re: tFileRowCount Count Rows

Anonymous — Thu, 06 Mar 2008 23:23:08 GMT

For your information, tAggregateRow is not the most optimized component to perform a row count operation. The solution I gave would avoid to read the generated file once again.

Re: tFileRowCount Count Rows

Anonymous — Thu, 22 Oct 2009 20:12:47 GMT

Hello,
I used tFileRowcount -> tFixedFlowInput -> tLogRow to get the number of lines of a CSV File.
I want to use this result for a max_number in a loop, but I don't know how to call it.
In the TFixedFlowInput I have Column = linenumber, Value = ((Integer)globalMap.get("tFileRowCount_1_COUNT")).
Is linenumber the global variable ? how do I call a global variable in a loop?
Thank you very much ?

Re: tFileRowCount Count Rows

Anonymous — Fri, 23 Oct 2009 02:49:12 GMT

Hello
You can set this global var ((Integer)globalMap.get("tFileRowCount_1_COUNT")) as max_number directly in a loop.eg:
tFileRowCount
|
onsubjobok
|
tLoop--iterate-->do another transaction
On tLoop, set 'to' field as: ((Integer)globalMap.get("tFileRowCount_1_COUNT"))
Best regards

shong

Re: tFileRowCount Count Rows

_AnonymousUser — Mon, 06 Sep 2010 06:07:23 GMT

Hai ,
I tried tfilerowcount (onsubjob ok)--> tfileinput delimited (main)--> tlogrow
The job is running successfully but i dont see the output in tlogrow.Should there be some specifications made to get the output of count of file.

Re: tFileRowCount Count Rows

karthikj18 — Thu, 12 Jan 2012 09:59:08 GMT

Hi
While I use the tFileRowCount component to display the row count, its giving error.
tFileRowCount (main)--> TLogRow
Can anybody please explain how to get the total number of rows in a file using this component?

Re: tFileRowCount Count Rows

Anonymous — Mon, 02 Sep 2013 06:34:16 GMT

Hi friends how do i get the total number of rows in each column and what is the missing% in each column ..

Re: tFileRowCount Count Rows

Anonymous — Mon, 02 Sep 2013 07:31:47 GMT

Hi anigotiyara,

Hi friends how do i get the total number of rows in each column and what is the missing% in each column ..

what's your scenario? If you process with a column of file, you can use "Nb_LINE" to count the total number of records have been proceed.
let me explain it more detail, if you are executing an operation "Insert data into tmysqloutput", and this option is set to Inserted, a global variable ((Integer)globalMap.get("tMysqlOutput_NB_LINE_INSERTED")), will counts the total number of records have been inserted.
More information of requirement will be preferred.
Best regards
Sabrina

Re: tFileRowCount Count Rows

alevy — Tue, 03 Sep 2013 13:13:10 GMT

It sounds like you want to do data profiling. You should look at TOS DQ.

Re: tFileRowCount Count Rows

_AnonymousUser — Sun, 01 May 2016 15:12:10 GMT

Hi ,
My file is in S3. How do i get the count of records from the S3 file and load the record count to a table in Redshift?
Need Help.
Cheers,
mk

Re: tFileRowCount Count Rows

Anonymous — Thu, 21 Jul 2016 12:09:19 GMT

I need to read the output file name from tfileoutputdelimited like path context.Output_Path+"/"+"MART_PTNT_PRFL_LAB_"+TalendDate.getDate("CCYYMMDDhhmmss")+".dat" ..
After I need to create control file
I need to create a control File which has file name of above and Count the no of lines
Ex: filename.ctl
Inside data should like below
filename|xxx(count)

Re: tFileRowCount Count Rows

Anonymous — Fri, 22 Jul 2016 10:17:10 GMT

Hi sai8166,
What does your current job design look like?
For your job requirement, could you please elaborate your case with an example with input and expected output values?
Best regards
Sabrina

Re: tFileRowCount Count Rows

Anonymous — Tue, 03 Jan 2017 06:49:15 GMT

I am very new to talend. Currently, I am using Talend for big data 6.2. Now, I have simple scenario to get the record count coming from xml file.

Re: tFileRowCount Count Rows

Anonymous — Tue, 03 Jan 2017 07:55:27 GMT

Hi VISsu,
For your requirement, could you please elaborate your case with an example with input and expected output values?
Best regards
Sabrina