You are not logged in.
Announcement
Unanswered posts
|
- Index
- » Usage, Operation
- » convert null value from tAggregateRow in 0
Post a reply
Topic review (newest first)
- 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.
- 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?
- 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
- 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.