on 12-26-2014 8:04 PM
Hi Experts,
I have a file to jdbc scenario , the data coming from the tab delimited file is in decimals.
The issue is that the data with 0.004 is coming as 4E-03 , the way we would normally see it in excel sheet.
How do i convert this back to 0.004 ? any standard function?
Regards,
Teja
Hi, If you see the data in database table in incorrect format then you need to change the type of data in the database table to character.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi, Use standard function formatNumber in your message mapping. Enter number of zeros in format number function equal to permissible length of your target JDBC field.
Additionally, To handle values with positive exponential values (for example 2E+07)use if else condition to check value greater than 1 and handle it accordingly.
Best Regards,
Amol
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Ravi,
Please download payloads at each step of PI pipeline (same them as .txt, please use notepad++). Please let us know, in which step you see 0.004 converted to 4E-03.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
10 | |
10 | |
9 | |
6 | |
6 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.