Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

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

Output JSON to CSV adds unwanted quotes


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.





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 ;)