Number input without comma seperation.

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:

Gallery

Input

Data Investigation

Accepted answers

RSreeSurya

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.

All comments

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

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-excel-output/td-p/574172

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

0530-NicoLehmann.yxmd

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703