topic Generate report to show row count from multiple outputs in Talend Studio

Generate report to show row count from multiple outputs

Anonymous — Fri, 22 Mar 2019 19:50:28 GMT

Hi,

Please advise me below -

I am trying to create another report to show multiple output row count. Below is example of what I want -

For now I have created 3 different reports under 3 different jobs.

report A - rows in output file are 100

report B - rows in output file are 300

report C - rows in output file are 60

I would like to create a new report under a new job shows below stuff -

report name Count

A 100

B 300

C 60

I hope I can get solution. Thanks!!

Re: Generate report to show row count from multiple outputs

vapukov — Fri, 22 Mar 2019 21:50:26 GMT

Hi,

one of the standard ways - enable statistics and meters collection

then in the Job define what you want to collect

and you will have data for any feature report, check there - https://help.talend.com/reader/hm5FaPiiOP31nUYHph0JwQ/FZO4Y1KoUlznLmxtOgoqgA

about the table (file) structure

regards, Vlad

Re: Generate report to show row count from multiple outputs

Anonymous — Mon, 25 Mar 2019 14:06:24 GMT

Thanks.

The thing is I know the count for each output after run. I would like to create another report with excel file outputing automatically the count for each record. I don't know how to achieve this.

Re: Generate report to show row count from multiple outputs

vapukov — Mon, 25 Mar 2019 22:49:03 GMT

you could, at the end of the job (or in postJob section) create simple construction

tFixedFlowInput - define the schema and assign values from knowing variables
connect tFixedFlowInput to tExcelOutput
use it

Re: Generate report to show row count from multiple outputs

Anonymous — Tue, 26 Mar 2019 15:09:58 GMT

Hi,

I connect my outputs to tFixinput and then connect a tExcelOutput. the result I want to deliver is in one excel file (texceloutput) I can have below contents when I open it -

Report name	count
A	0
B	1
C	3524

I attached my workflow but I do not know how to show the row count of outputs into that excel file

Currently when I open the excel output, I got report name because I manually enter in tFixInput, but I don't know what function can help me deliver the row count.

Please advise how I can configure to deliver the result. Thanks!

Re: Generate report to show row count from multiple outputs

akumar2301 — Tue, 26 Mar 2019 15:20:51 GMT

((Integer)globalMap.get("tFileOutputExcel_1_NB_LINE"))

Explore tFlowMeter

https://help.talend.com/reader/NNO~fmVQU4rlkF9Depfdxw/sNxtJ3SnFfCvI1wK42NXDQ

Re: Generate report to show row count from multiple outputs

Anonymous — Tue, 26 Mar 2019 15:36:41 GMT

Hi,

Thanks! I tried that function but I got type mismatch error - cannot convert integer to string. I am not sure why I have this error.

Below is what I did for tFixInput

Re: Generate report to show row count from multiple outputs

akumar2301 — Tue, 26 Mar 2019 15:48:02 GMT

Error count should be int type not String.

Re: Generate report to show row count from multiple outputs

Anonymous — Tue, 26 Mar 2019 16:28:19 GMT

Yeah I agree with you. But how can I fix this error to get the correct result? Please advise

Re: Generate report to show row count from multiple outputs

akumar2301 — Tue, 26 Mar 2019 18:42:27 GMT

I am not sure why you want to make it string but you could convert integer
to string like this

(Interger)globalMap.get(...) + “”

Re: Generate report to show row count from multiple outputs

Anonymous — Tue, 26 Mar 2019 18:58:02 GMT

Thank you I think I have figured out and it works for now!