Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

tFileRowCount Count Rows

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

Labels (2)
19 Replies
_AnonymousUser
Specialist III
Specialist III

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.
karthikj18
Contributor III
Contributor III

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?
Anonymous
Not applicable
Author

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

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
alevy
Specialist
Specialist

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

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
Anonymous
Not applicable
Author

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)
Anonymous
Not applicable
Author

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
Anonymous
Not applicable
Author

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.
Anonymous
Not applicable
Author

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