This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Also, I'm not sure I understand exactly what you mean by saving it as xlsx. Do you mean to open the jumbled up csv and save it again as xlsx or do you mean to use a different output tool in alteryx and output directly to excel? If the former, yes, even after saving again as XLSX, it's still all stuck in 1 column. If you mean the latter, exporting to XLSX directly from alteryx works as intended. I don't have any issues with that.
@danilang Yes indeed I am from a region that uses comma as decimal separator. Unfortunately I can't change this because I specifically need amounts to be separated by comma at their decimal point, not a dot.
I was wondering if there was a way to fix the csv file directly from inside Alteryx (to minimize human interaction) without having to change regional settings that affect my amounts format.
I meant the latter, using a different output tool. I would have to agree with @danilang with the problem being using a coma as a decimal separator as there is no issues when outputting as an xlsx. Is there a reason why you specifically need to use a csv?
It looks like there are 2 ways to modify the CSV, both with drawbacks
The 1st is to use semi-colon ";" as the delimiter. This is the default that excel looks for when a comma is used as a decimal separator. This opens properly with "999 999,99" but opens in one column if your settings are "999,999.99"
The 2nd is to add a an extra first row with the text "sep=," as in
adding the extra line, automatically makes the file Excel specific. The csv format is now broken as far other programs, including Alteryx, are concerned causing errors on input
The choice is up to you.
Of course a 3rd option is to follow @Jonathan-Sherman's sage advice and save to .xlsx if you can.