community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

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

Output JSON to CSV adds unwanted quotes

Nebula
Nebula

hi @fpinchon 

 

Indeed you can't win.  Like I mentioned in the last line of my post, you can't do it directly.  You have to build the line as a single field, including the comma and output just that one field

 

Something like this will output the format you're looking for.  Of course, since it doesn't conform to the CSV standard, you'll need a custom routine to parse it.

 

WF.png

 

Dan

Alteryx Partner

Awesome effort @danilang I actually thought of this overnight, just wrote the workflow in Alteryx, got it working perfectly and you've posted almost the identical workflow 7hrs earlier :)

 

I think the BIG warning is - this is NOT a proper CSV file, most CSV readers will NOT read it properly so I'd very VERY cautious in using this in a production environment.

 

But it does answer the question posed ;) 

Labels