Hi,
I have a input stage and pass it to aggregator stage and insert the count in sequential file
If i have 0 records in the file i want to update the count as 0. But it is updating the file with Null..
Is there a way to do that?
aggregator question
Moderators: chulett, rschirm, roy
There is a sub property for the aggregrator stage under Option tab-- "Allow Null Output". Set it False.
Here is the details of the property...
If it is set to True means that NULL is a valid output value when calculating minimum value, maximum value, mean value, standard deviation, standard error, sum, sum of weights, and variance. False means 0 is output when all input values for calculation column are NULL.
Here is the details of the property...
If it is set to True means that NULL is a valid output value when calculating minimum value, maximum value, mean value, standard deviation, standard error, sum, sum of weights, and variance. False means 0 is output when all input values for calculation column are NULL.
Rgrds,
Abhi
Abhi