Hi Im using an alteryx xlsx to csv converter, which converts , to . in the output.Any way to change this ?Using this macro kind regards
I think one of the problems here is, if there are commas (,) in your data and you write it to a CSV that uses comma as a separator, it will mess up the structure of your data.
I looked at the file and what the macro does and I think it's probably easier just to build the workflow from scratch without the macro. It seems that there is a structure in the Excel file that we can rely on, so have a look at the attached workflow and let me know if it works for you.
I've changed the CSV delimiter to a pipe (|) rather than a comma, but this can easily be changed in the Output data tool if you like, as long as it's not a comma.
could you provide an input file for the macro?
Hi Here is a copy of my input file 🙂
