How to use unit separator as delimiter in alteryx

[msaxen2]

I have trying to create a file with unit separator and i m not sure how to do it. I have attached a screen shot of file header. Instead of comma or tab or any other delimiter,  I m looking for unit separator as delimiter. Please let me know if i m not clear i will try to provide some more information . Thanks for the help

[Claje]

Having never tried this before, try using this as your delimiter:

\u001f

Let me know if that works, or if there's an issue!

[msaxen2]

It didnt work. It throws an error attached is the error

[Claje · Accepted solution]

I also ran into some challenges getting this to work just using the output tool - particularly because it seems like most windows applications (Alteryx included) don't display this character by default.

There may be a better way to do this, but I've attached a workflow that I believe will support your output format.  Basically, by consolidating every row into one field and creating the delimiter using a formula, we can output to a "non-delimited" file using this custom delimiter.

let me know if this helps!

[msaxen2]

This is perfect, exactly what i was looking for. Thank you so much