Hi, I have input that looks like this
and when I use Number To string node, I get this output
Why does string get decimal point and it looks like float? I need the string to remain looking like integer. What can I do, can someone help please?
how about you do first double to int and then number to string?
Because you have a double column type and although it’s written as 1 it’s actually 1.0 (or something similar). Revisit your flow and check where you got Double column type - if you’ll always have integers in it make sure you don’t get Double type there
Besides @Martyna’s suggestion you can also use String Manipulation node with following expression:
Column Auto Type cast reads them as double. I don`t know how to affect this.
Excel Reader gives me this.
Then Column Auto Type cast node reads these numbers as double, and number to string node adds a decimal point.
Thanks Martyna, that worked.
Great to hear it’s working
With respect to the Excel Reader. You can go in the configuration of that node to the Transformation Tab and there you could change the Type as well.
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.