Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

Error in csv output

harsha384
8 - Asteroid

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

11 REPLIES 11
grazitti_sapna
15 - Aurora
15 - Aurora

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

 

grazitti_sapna_0-1602741557165.png

 

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

Thanks.

Sapna Gupta
harsha384
8 - Asteroid

Hi @atcodedog05 ,

 

Thank you for your response.

 

Unfortunately it didnt worked for me. 

My data size is around 4k records.

One of the column has value like

         Col A                                                           Col B

" #xyz@aa.com; def@vv.com;xyz                        test

 

Now Col A is getting split into rows which I don't want (My requirement) . My delimiter is pipe | 

 

Inspite of putting delimiter as | , my records are getting split into rows based on ; as mentioned above

 

Any reason why or any other solution it?

 

Thanks

Harsh

Labels