Upgrading Server to version 22.1? We’ve enabled the faster AMP engine by default. Read about how these system settings changes might affect you.

2022-05-26 Updates: Email: If you're not seeing emails be delivered from the Community, please check your spam and mark the Community emails as not junk. Thank you for your patience.

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
Qiu
19 - Altair
19 - Altair

@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
14 - Magnetar

 hi @harsha384 

It seems to work fine on my side:

TheOC_0-1602677222554.png


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:

TheOC_1-1602677358567.png

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

TheOC_2-1602677387323.png

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

TheOC_3-1602677408961.png


Data should now look correct

harsha384
8 - Asteroid

Hi All,

 

Please find attached input and ref output file.

 

I am using output tool config with delimiter as |

atcodedog05
22 - Nova
22 - Nova

_

atcodedog05
22 - Nova
22 - Nova

Hi @harsha384 

 

Is the attached output the expected output 

atcodedog05_2-1602687380286.png

or is this the expected output

atcodedog05_1-1602687333133.png

If you clarify, I can help you out 🙂

atcodedog05
22 - Nova
22 - Nova

Hi @harsha384 

 

Here is a workflow give both scenario outputs.

atcodedog05_0-1602687746407.png

 

Please check and let me know🙂

 

harsha384
8 - Asteroid

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
22 - Nova
22 - Nova

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

atcodedog05_1-1602689759989.png

Excel

atcodedog05_0-1602689740052.png

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

 

 

echuong1
Alteryx Alumni (Retired)

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

Can you upload the workflow that you created?

 

echuong1_1-1602722709893.png

 

 

echuong1_0-1602722666088.png

 

Labels