Generate report to show row count from multiple outputs

[Anonymous]

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!!

[vapukov]

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

[Anonymous]

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.

[vapukov]

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

[Anonymous]

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!

[akumar2301]

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

Explore tFlowMeter

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

[Anonymous]

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

[akumar2301]

Error count should be int type not String.

[Anonymous]

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

[akumar2301]

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

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