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:
Solved! Go to Solution.
Hi @NicoLehmann ,
If you could share your input file and the workflow, I will update your workflow accordingly.
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...
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.
@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