Number to String creating decimal numbers out of integers

Hi, I have input that looks like this
image

and when I use Number To string node, I get this output
image

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?

Best regards

Hi,

how about you do first double to int and then number to string?

Best,
Martyna

3 Likes

Pozdrav @Dalmatino16,

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 :wink:

Besides @Martyna’s suggestion you can also use String Manipulation node with following expression:
string(toInt($column1$))

br,
Ivan

3 Likes

Bok Ivane,

Column Auto Type cast reads them as double. I don`t know how to affect this.
Excel Reader gives me this.
image

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 :slight_smile:

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.

Best
Martyna

4 Likes

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.