Tab delimiter from Excel in Alteryx

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

alteryx interface.JPG

Topic of Interest

Accepted answers

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

All comments

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

Hi Kucsi,

It totally works for me.

I really appreciate your help.

Jorge

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

Quick Links

Tags

This months top contributors

atcodedog05 19598

Qiu 15867

MarqueeCrew 13708

apathetichell 13703