I haven't found any solution for this strange behavior and it's hard to believe it is not doable.
I am loading an excel spreadsheet, and matching it with a SQL table on a COMMON NUMBER-LOOKING STRING COLUMN to find delta.
I don't seem to have any issue with the processing of workflow itself, however when I export the result into a CSV file, the very same column changes to 1E+12 format.
As it can be seen in highlighted, the equipment column looks OK up to the last "input connector" of the output tool. however, the below snippet shows the same column turned into scientific notation.
I have tried to add an apostrophe before the string to force it to perceive it as string but that added an extra character at the beginning of the number-looking-string. Excel perhaps would understand that but CSV is not that smart. Regardless, I can't add any leading space to it because there is another procedure takes this file and loads into a live table. I also tried adding following formula but that didn't help either.
What I want is for this string column to be exported as it is in CSV.
Any idea where I am dropping the ball?
Thanks in advance.