Text to column import not working

Question

Hello

i have been importing data from a file which needs to be delimited by commas which i have been doing via the import tool.there are some commas in numbers that are 1,000 and above but the ignore delimiters in commas is not working which is resulting in the number being cut, so a number of 1,200 will come in alteryx as 1. below is what the data looks like and also the import tool setup. please help.

echuong1 · Answer

That is expected, because the commas make the data text, not numeric. You cannot just use a Select to adjust the field type in that case. You need to remove the commas first.

I adjusted the multi-row formula to remove commas as well. Hope this helps!

If this resolves your issue, please mark as solved so others can find answers more easily.

New Workflow1.yxzp

Usamah22 · Answer

i have copied your workflow from the image and it seems to work except when i then change the format from a vw string to a double it cuts the number again at the comma

Usamah22 · Answer

it looks like i have an older version of Alteryx so cannot open this.

When i try to get rid of the comma in delimiters in the input tool it still splits the data into columns itself. I can't seem to input the whole dataset as it looks in the csv.