Alteryx Designer Discussions

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

Tab delimiter from Excel in Alteryx

jplasencia-itp
6 - Meteoroid

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

5 REPLIES 5
Kucsi
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

jplasencia-itp
6 - Meteoroid

Hi Kucsi,

 

It totally works for me.

 

I really appreciate your help.

Jorge

Kucsi
8 - Asteroid

No problem. 🙂

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

Hi Kusci, 
i basically have the same issue but the solution does not work out for me.

Maybe I have a more

 

difficult data set as based on the SAP output I get the same headers over and over again. Good ideas?

Labels