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.
Aggregator Convert from Double to VARCHAR
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 40
- Joined: Thu Jul 10, 2008 12:45 pm
Aggregator Convert from Double to VARCHAR
Srikanth Reddy
Integration Consultant
Integration Consultant