In spoon transformation, format should be # and that should take care of it..btw, what is the remedy field data type? Can you manually put number in the remedy form, save it and check if that converts into decimal?4 of 4 people found this helpful
If yes, you need to change the field property so that it only accept numbers.
If no, add ‘select value’ step in the transformation (before inserting value in remedy) with format as a # and try again.
1 of 1 people found this helpful
If you don't store a number as text in the Excel sheet, Excel adds the decimal places when converting to CSV.
See if you can have the source spreadsheet store.the number as text.
Completely agree with Ganesh.