topic How to output job's data count in log in Talend Studio

How to output job's data count in log

hzhen — Sat, 16 Nov 2024 01:36:08 GMT

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

thanks

Re: How to output job's data count in log

Anonymous — Tue, 25 Aug 2020 02:04:58 GMT

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

Re: How to output job's data count in log

hzhen — Tue, 25 Aug 2020 08:03:51 GMT

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?

Re: How to output job's data count in log

Anonymous — Tue, 25 Aug 2020 08:23:00 GMT

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

Re: How to output job's data count in log

hzhen — Wed, 26 Aug 2020 02:24:32 GMT

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?

Re: How to output job's data count in log

Anonymous — Wed, 26 Aug 2020 09:22:05 GMT

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