Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Removing commas from field

kevinraj127
7 - Meteor

Hi everyone, I'm fairly new to Alteryx and have been using the tool for a few weeks. I built a workflow that produces a report showing a six digit number identifying a gas leak in a geographical area. The output is formatting the "leak key" field with a comma in the middle (ex 575,795), and I want the output data to not have the comma. The data type for the field is "Int32". I tried using the data cleansing tool to remove punctuation, but the report output is still showing a comma for the leak key. I'm getting the data for the workflow from a SQL Server database. Any thoughts how I can fix this issue? Thanks for your help! picture of workflowpicture of workflow

 

 

Data type for  leak keyData type for leak key

Data Cleansing for comma.JPG leak key output in report (would like to remove commas)leak key output in report (would like to remove commas)

2 REPLIES 2
jrgo
14 - Magnetar

@kevinraj127,

 

Numeric values, when processed through the reporting tool, add comma's and I don't believe there's a way to rid the values of them if you need them to stay as numeric field types. Only way to do so would be to convert those fields to one of the string field types, which you can do in the Select tool you're showing. The "Table" tool will treat it as such and not add any commas. However, if you're "Render"ing to Excel, the sheet will have this value attributed as a TEXT field, not numeric.

 

Hope this helps!

 

Jimmy

kevinraj127
7 - Meteor

Thanks Jimmy! This worked, when I changed the data type to "String" in the Select Tool, it removed the commas in the output report. Thanks very much for your help!!

Labels