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

Announcements
Write Table now available in Qlik Cloud Analytics: Read Blog
cancel
Showing results for 
Search instead for 
Did you mean: 
hzhen
Contributor III
Contributor III

How to output job's data count in log

I want to get data counts in logs, How to get this.

thanks

Labels (3)
5 Replies
Anonymous
Not applicable

Hi

Usually, there exists global variable that counts the total number of data are read from data source or written into target applications. Such as:

((Integer)globalMap.get("tDBInput_1_NB_LINE"))

 

Can you please explain what kind of data you want to get the count?

 

Regards

Shong

hzhen
Contributor III
Contributor III
Author

thanks for your help and support.

eg: A job's input csv file has 10 records. After this job is executed. I want to see the record counts(10) in log file.

can it do this?

Anonymous
Not applicable

You can use the global variable ((Integer)globalMap.get("tFileInputDelimited_1_NB_LINE")) while you are using a tFileInputDelimited to read the file, and output the count to a log file. eg:

tFileInputDeliited--main--BABABAA

|onsubjobok

tFixedFlowInput--main--tFileOutputDelimited.

 

Regards

Shong

hzhen
Contributor III
Contributor III
Author

Thanks for your answer.

((Integer)globalMap.get("tFileInputDelimited_1_NB_LINE"))​

((Integer)globalMap.get("tDBInput_1_NB_LINE"))

That document has what you said?or where is API document?

​Can you tell me?

Anonymous
Not applicable

Hello,

About the row count using global map variable, please have a look at this component references and related scenario as follows: TalendHelpCenter: tFileInputDelimited and TalendHelpCenter: Using variables in a Job

Feel free to let us know if it works.

Best regards

Sabrina