Alteryx Designer Desktop Discussions
Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
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.
Looks like I was able to successfully parse with the text to columns. For the text to columns you can adjust the number of columns made to match your data - looks like there are 19 but I selected 20 just in case (hence why there is an empty column at the end). I then used a multi-field formula to remove the quotation marks, a sample to remove the extra lines of headers, and a dynamic rename to bring the actual headers up.
It looks like there are a couple of fields that don't have headers (matches the original file as well), so check those.
Hope this helps!
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.
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.
