Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Andy Uttley, Alteryx ACE, makes music with Alteryx | Math + Music
SOLVED

Tab delimiter from Excel in Alteryx

Highlighted
Alteryx Certified Partner

Hi guys,

 

Currently, I'm trying to automate a business process which input is a txt and giving format in Alteryx. Do you know some similar way to work this file as Excel does with the tab delimiter? Because when the txt is set in Alteryx as a csv it ask for delimiters and the parsing doesn't work properly the result is one column and I need to see the data split in the order showed at the excel output file.

 

See the workflow model in Alteryx attached and the images from Excel and Alteryx interface below.

 

Regards

Jorge

txt.JPGpaso1.JPGpaso2.JPGalteryx interface.JPG

Highlighted
8 - Asteroid

Hi jplasencia,

 

try this configuration on the input file:

image.png 

 

If it doesn't work, when you drag the txt into alteryx you will get a message, try this config:

image.png

 I hope it will work for you :)

 

Kucsi

Highlighted
Alteryx Certified Partner

Hi Kucsi,

 

It totally works for me.

 

I really appreciate your help.

Jorge

Highlighted
8 - Asteroid

No problem. :)

Highlighted
5 - Atom
I had the same question. Thanks for responding. It worked for me too!
Labels