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

How to use unit separator as delimiter in alteryx

Highlighted
Meteoroid

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

 

Magnetar
Magnetar

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

 

\u001f

 


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

Meteoroid

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

Magnetar
Magnetar

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!

Meteoroid

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

Labels