This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
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.
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 ;)