Creating a .csv with multiple formats

[brianscott]

Hello gurus - 

For some reason, our vendor wants a csv that has multiple record definitions within the same .csv

type, action, account, name

A, add, 012345, 'brian'

A, update, 23456, 'scott'

type, action, address, major_malfunction

P, add, 942 evergreen terrace, 'insufficient funds'

P, delete, 300 main street, 'Main street closed due to lack of interest'

Gathering the data is easy.  Getting it out into a single .csv is a little more vexing.  Anyone have any ideas?  

Thanks. 

brian

[BenMoss · Accepted solution]

What issue are you facing exactly when trying to write this to a CSV?

I would consider building all of this and writing it as an 'undelimited' csv file (\0) but you will have already built the '.csv' structure within the workflow, by adding delimiters and qoutation marks where applicable.

If that makes any sense.

Ben

[brianscott]

 Hi Ben - 

I'm getting close.  I can't make Alteryx undelimit at output time; i.e., I'm getting 

"all,of,my,data,enclosed,in,quotes"

"how,do,I,tell,it,to,just,output,my data,as it stands"?

Thanks. 

[brianscott]

Nevermind!  

'Quote Output Fields':  'Never'

Thanks for the idea, Ben.  You got me on the right track.

brian