Now that it's live, don't forget to accept your certification badge on Credly today! Learn more here.

Alteryx Analytics Hub

Find answers, ask questions, and share expertise about Alteryx Analytics Hub.

Text output via csv

Ash_dsz
6 - Meteoroid

Hi All,

 

I am stuck on the below part of my canvas and it would be great if anyone has any method to generate the below mentioned output.

The below is just an example of the data that I am stuck on and you can consider it as an input as well.

 

Tax_0Data_0Path
Tax=0 C:\Users\Downloads\Tax
A112,A114 C:\Users\Downloads\Tax
 Data=0C:\Users\Downloads\Data
 A113,A115C:\Users\Downloads\Data

 

Basically the desired output should generate in a text format without the quotes and also in different folders that i have mentioned above. Just an example of the desired output.

 

In folder C:\Users\Downloads\Tax the required output is .txt is

Tax=0

A112,A114

 

In folder C:\Users\Downloads\Data the required output is .txt is

Data=0

A113,A115

 

Currently in the canvas output when i use .csv and try to generate this output I'm stuck on the following pointers .

1. If the first line is a delimiter there will be quotes. But i need  to make sure that my first line is a delimiter without the quotes in. (I have tried parse and formula tool as well but I'm not sure if its working for me.)

2. Also  for Data folder output i am getting a ( , ) before the data.

 

Thanks,

Ash.

 

 

1 REPLY 1
Joe_Lipski
13 - Pulsar
13 - Pulsar

Hi @Ash_dsz 

 

Could you try changing your delimiter to something else, e.g. |

 

And then you can change Quote Output fields to Never:

 

Joe_Lipski_0-1632899959992.png

 

It will error if you change quote output fields to never when you are using a comma IF you have a comma in your data.

 

Please let me know if this helps at all.

 

Cheers,

Joe Lipski
Labels