Trying to load a data from an .xls file using Excel input Step and In the spreadsheet if a a column has with alphanumeric and numeric content.
The alphanumeric content is treated as a string. But the numeric content in the column is append with .0 and loading into the database
("string" like 1100 get changed to 1100.0).
We have changed the metadata of the column to string before "Table Output"
Steps to reproduce:
1. Please find the attached transformation.
2. Add the xls file to the Excel input step.
3. Take preview in the select values which will show .0 appended to the numeric value.