Delimiter in the csv file

[NanditaPatil]

My Alteryx csv output has delimiter without defining it, I am trying to get the each field name in separate column but they are all coming in a single cell with a delimiter(,). Image1- output. Image2- expected output. Image3- Output settings

[BrandonB]

Can you parse it using a text to columns tool after bringing it in? You can then use a Dynamic Rename tool to set the first row of data as the new headers after parsing out to set your column names. 

[NanditaPatil]

I can do that but I feel there is something to do with settings because every time I export the csv I will have it all in the same cell and I will need to use text to columns 

[BrandonB]

At a glance it looks like you don't have a delimiter chosen in the #3 setting. What happens when you put a comma in there?

[NanditaPatil]

I got this output with comma delimiter

[BrandonB]

Can you check the box for first row contains field names?

[rohityaman]

Could you please share the screenshot of the Alteryx workflow? And also the screenshot of the result window selecting the input port of the Output tool?

[NanditaPatil]

Here is the screenshot having both

[rohityaman]

Just change the "code page" configuration to 'Unicode UTF-8' or 'ISO 8859-1 Latin I', it will work. Also, mention comma as delimiter.

[NanditaPatil]

Dint work