Number input without comma seperation.

[NicoLehmann]

Hi,

I have some Sql Inputs. I'm reading there an Integer input and everytime in the output i got commas there that i don't want.

Thats the output: and in the WNR column i got this commas:

I was already able to change this in the input with the Localisation settings. But in my output there is still these commas. 

How can i remove them.

Thats a part from my workflow:

[RSreeSurya]

Hi @NicoLehmann ,

If you could share your input file and the workflow, I will update your workflow accordingly. 

[NicoLehmann]

Maybe can you just tell what to do. It's difficult to share because it's all from company, and company data inside the workflow...

[RSreeSurya · Accepted solution]

Hi,

The table tool adds the commas for numeric datatypes. Please try converting to string and even after that , if you are able to see commas, then please change to string type and use below formula.

replace([WNR],',','')

Hope this works. 

[Qiu]

@NicoLehmann 
I would like to just add something.
As mentioned by @RSreeSurya , it is a default setting of Table tool.
https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Get-rid-of-commas-in-numbers-e...

We can change it by change the data type to String before entering Table tool