How to Read .txt File in alteryx

[CHandrash12]

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

[atcodedog05 · Accepted solution]

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 😀👍

[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)

[atcodedog05]

Happy to help 🙂 @CHandrash12 

Cheers and Happy Analyzing 😀

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