DSXchange

Hi,

Could you please let me knw How to convert Double datatype to Decimal from the Aggregator for the Count operation?

Thanks,
Vijaykumar P J

There is a property called something Default Decimal Output that can be set globally (within the Aggregator stage) or for individual columns. You set the precision and scale for the decimal number, separated by a comma. You can also use this property if the target field is an integer of some kind (scale is zero in this case, of course).

ray.wurlod wrote:There is a property called something Default Decimal Output that can be set globally (within the Aggregator stage) or for individual columns. You set the precision and scale for the decimal number, s ...

Hi Ray,

That is the property only if we select the operation as Calculation. This option will not be available if we are doing Count operation.


Thanks,
Vijaykumar P J

That's true. When Count is the operation you have to accept Double as the output data type (or tolerate the warning message). You can change it with a downstream stage, such as a Modify stage.