I've got a couple of work flows pulling data from different tables into one table. Some of the data I am pulling is coming in as a decimal number i.e. 3.7, 4.5, some of it is coming in as whole numbers, for the decimal some of the numbers are 0.0.
The destination table column is set to varchar as there are different data types coming from 3 different tables, so just convert all to string.
When I pull the any (0.0) data into the destination table it removes the leading zero to show .0
I know you can do transformations or sql wizardry at the query level but it seems to be once the data is put in the table a leading zero is removed. I understand this is because the field is a varchar and removes the leading zero
How can I reinsert the leading zero if it is value .0 to change it back to 0.0?