Alteryx excel output issue

[henrygeorge]

HI team,

I have a column that contains numbers however, the file keeps showing comma separators. I don't want such comma separators so I changed it to v_string. Now it shows up without commas, however I see green triangles on each cell and also have to covert to number all the time

Please help he just have a number without comma. 

Eg: 345677 not 3,456,77 and not 345677 with a green triangle

I know there's a way in excel to remove the green triangles but I still have to convert them to number which is not good. 

[vizAlter]

@henrygeorge — Can you attach sample data and workflow, if possible.

[henrygeorge]

@vizAlter i can't attach my Workflow but here are some pictures.. 

 

[Ben_H]

HI @henrygeorge

Excel is reading these columns as numbers stored as text because that's how you have them formatted in Alteryx.

You need to convert them to numeric fields.

If your existing columns are already strings and have commas included you can use the data cleansing tool on specific columns you need to remove punctuation, then just change the field type in your select tool.

Regards,

Ben

[vizAlter]

@henrygeorge  — Please attach the workflow, if not let me know.

Looks that data is stored in Text, hence you are getting output in Text format for the number field.

You need to set the number format using a Formula tool ToNumber([Amount]) with Double data type.

[henrygeorge]

@Ben_H

The data cleansing punctuation removal didn't solve it sadly. It's still showing the commas in the final file

@vizAlter

Thanks for the workflow

I can't change the data type to Double when pushing to number

  

[vizAlter]

@henrygeorge —  You need to create another column using a Function tool. >>> Use a correct datatype in your function >>> Once you are satisfied with the results in the new column then use a "Select" tool to exclude the original field, and keep the new field with rename.

[henrygeorge]

@vizAlter

Did the same but this is the output

 

[vizAlter]

@henrygeorge — What is the data type in your Alteryx workflow? and what is the datatype showing in your Excel sheet? Looks good?

[henrygeorge]

@vizAlter it's Double in Alteryx and Number in Excel

How do I remove the commas? I tried using data cleansing and still it doesn't work

In my output it's also resulting in no commas but when outputting it gives out a comma