Talend community forum / convert null value from tAggregateRow in 0

Kawltonn · 2010-05-14 22:57:25

Hi,

I need help to change and print in tLogRow when tAggregateRow Value is 0.

could you please help me?

Here is my Job :

tMap --> TAggregateRow --> tLog

In tAggregateRow I count the number of row and return the result to tLogRow.

The problem is if there is no row, there is no value print on console.

Is it possible to print 0 on this console?

Thank you for your help.

shong · 2010-05-17 03:19:53

Hello
It is impossible to print 0 if there is no ro ws, you can monitor the flow and use a tFlowMeterCature to capture the flow info. There is a 'count' field count the number of rows.

Best regards
Shong

Uploaded Images

Kawltonn · 2010-05-17 17:15:19

Hello shong,

first I want to thank you for your answer.

I give you more details about my pb.

From a tMap I get 3 output.
Each output go on a tAggregateRow. This Aggregaterow is used to count the number of row.

I want to put the result of each count value in a file (i.e. Excel .csv file).
Everything work well when the count is >0 , but when the count i=0, no value print.

Your solution with tFlowMeterCatcher will complex the job because of I give you an example for 1 tMap and 3 AggregateRow, but the job contains 4 tMap and 12 tAggregateRow.

Have you got other idea?

Uploaded Images

Last edited by Kawltonn (2010-05-17 17:23:48)

alevy · 2010-06-07 03:07:07

There is a way but it's unpleasant: you can follow each tFileOutput with a tFixedFlowInput (joined with a RunIf) and then another tFileOutput e.g.

Uploaded Images

Last edited by alevy (2010-06-07 03:11:01)

Announcement

Unanswered posts

#1 2010-05-14 22:57:25

convert null value from tAggregateRow in 0

#2 2010-05-17 03:19:53

Re: convert null value from tAggregateRow in 0

#3 2010-05-17 17:15:19

Re: convert null value from tAggregateRow in 0

#4 2010-06-07 03:07:07

Re: convert null value from tAggregateRow in 0

Board footer