I have an input data in integer format as below :
150000
10000
1099
Is there a function in DataStage to convert the above integer into :
1500.00
100.00
10.99
I am thinking about converting to CHAR , SUBSTRING and concatenate the "." But it doesn't seem very efficient.
How to convert integer data to float
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 13
- Joined: Wed Apr 07, 2010 11:50 pm