DSXchange

Posted: **Thu Mar 29, 2007 1:25 pm**

hi,
I need to use the aggregator stage to aggreagte few numeric fields. Apart from that I have a string field for which I need to get the max() of it. The output is throwing as all zero's. Is it that aggregator doesn't work on string fields?? How can it be done?

Thanksin advance

Posted: **Thu Mar 29, 2007 3:47 pm**

Aggregator has nothing to do but the max() forces to throw an error. Convert your string to Numeric before sending it to aggregator.

Posted: **Fri Mar 30, 2007 1:27 pm**

[quote="us1aslam1us"]Aggregator has nothing to do but the max() forces to throw an error. Convert your string to Numeric before sending it to aggregator.[/quote]

USe the preserve type property set to 'True' and it will work

Posted: **Tue Apr 03, 2007 9:21 pm**

If you are on 7.5.1 you will have to apply a patch to use preserve type property. Contact IBM support.