Page 1 of 1

Aggregator Convert from Double to VARCHAR

Posted: Thu May 26, 2011 8:39 pm
by srireddypunuru
I am using Aggregator to get the Max Value once i do that i get the output in the double datatype as expected. The output what i get is 7604 but expected is 007604.I will be using this data for join in the next Join stage but my join is failing as output isnt as expected as 007604.

2 Questions.

1) How do i convert Double or Float to Varchar as my join key filed in further stages is VARCHAR.
20 I tried using DfloattoStringNoexp but it was giving exponential values.

Any suggestions will help !

Thanks
Sri.