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

Developer

Output

Transformation

Preparation

Data Investigation

Accepted answers

All comments

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 |

Book1.xlsx

grazitti_sapna

Hi @harsha384 , seems to work fine for me as well.

If you could provide us a sample workflow, we can investigate the issue and provide the solution.

Thanks.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703