Error in csv output

[harsha384]

Hi All,

I am creating pipe-delimited csv output. Output tool configured accordingly ( | ) .

One of the column has value like -

abc;def;ghi;xyz

Now when I open the written csv file, my count of rows increases because above column splits into rows like -

abc

def

ghi

xyz

While other columns are delimited properly based on | seperator.

Can anyone suggest?

Thanks

Harsh

[Qiu]

@harsha384 
Could you provide a sample workflow so we can check?

Or you can just format the data in Alteryx then just simply output the data?

[TheOC]

 hi @harsha384 

It seems to work fine on my side:

Can you upload a workflow showing whats happening on your side?

If you are opening it in Excel, then the problem lies in excel trying to work out what the delimiter is. If you follow these instructions it should fix it for excel:

Go to Data - from text/CSV, choose the file you're using.

Set the delimiter to be a pipe, and load the data.

Data should now look correct

[harsha384]

Hi All,

Please find attached input and ref output file.

I am using output tool config with delimiter as |

[atcodedog05]

_

[atcodedog05]

Hi @harsha384 

Is the attached output the expected output 

or is this the expected output

If you clarify, I can help you out 🙂

[atcodedog05]

Hi @harsha384 

Here is a workflow give both scenario outputs.

Please check and let me know🙂

[harsha384]

Hi @atcodedog05 ,

No that is not the expected output. This is what is happening now.

I wanted it to be only delimited by |.

But ; is getting splitt into rows.

[atcodedog05]

Hi @harsha384 

Check the second the scenario i guess that what you are trying.

The workflow has both outputs can you check and let me know 🙂

Outputs:

Notepad

Excel

Please check and let me know if it works for you 🙂

[echuong1]

Can you try the attached? It doesn't seem like any specific configuration is needed.

Can you upload the workflow that you created?