How to Read .txt File in alteryx

Hello All,

I am new to Alteryx and need help to read below text in a columns as shown in snippet. I am able to read text file in Alteryx but it all comes in column. Need help. I need to achieve this with only input tool

Test Input

EmployeeID;Name;Age;Exp;Comments
100;Warren,Ash;24;1.5;"Good;Employee"
101;Sue,Mary;27;3;"Avg; Employee"
102;Walter,John;30;4;"Bad;, Employee"

Expected Output

Regards,

Chandrakanth.K

Datasets

Best Practices

Database Connection

Accepted answers

atcodedog05

Hi @CHandrash12

Browse the file apply the config like below.

Output:

Hope this helps 🙂

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

txt.yxmd

All comments

atcodedog05

Hi @CHandrash12

Browse the file apply the config like below.

Output:

Hope this helps 🙂

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

txt.yxmd

RolandSchubert

Hi @CHandrash12 ,

can could use an Input tool and configure t to read "delimited text file", use ";" as a delimiter.

Best,

Roland

PraphulSamavedam

Hi Chadrakanth,

Please find the attached workflow for the solution.

The following configuration has been used for reading the text file as delimited file.

Delimiter = ";"

Ignore Delimiter in = "Quotes" (for comments column)

read_txt_input_as_delimited_input.yxzp

atcodedog05

Happy to help 🙂 @CHandrash12

Cheers and Happy Analyzing 😀

Feel free to reach out if you face any other issues 🙂

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703