Tab delimiter from Excel in Alteryx

[jplasencia-itp]

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

[Kucsi · Accepted solution]

Hi jplasencia,

try this configuration on the input file:

 

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

 I hope it will work for you :)

Kucsi

[jplasencia-itp]

Hi Kucsi,

It totally works for me.

I really appreciate your help.

Jorge

[Kucsi]

No problem. :)

[Melody]

I had the same question. Thanks for responding. It worked for me too!

[Holger2910]

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?

[ZaidAlShaddadi]

Same error happened with me. The preview page is showing all information next to each other, with tabs in between, under a single column.

It seems the (\t) parameter - which suppose to detect the tabs - is not able to detect it. 

[pjt766]

This worked for me... just was unclear on the second piece of art.  How do you find the "resolve file type"?