Can someone help me in converting txt file to excel using Alteryx.

[Shivani1195]

There are 9 columns I want in excel.

[atcodedog05]

Hi @Shivani1195 

Can you provide some sample input file and expected output file It will help us get a better understanding of the usecase.

We will be happy to help : )

[Shivani1195]

This is the final output I want in excel and below is text file format. 

I was following below steps to covert txt file to excel but there is some formula error. Can you please help with this?

[atcodedog05]

Hi @Shivani1195 

can you provide the file as an attachment it will be easier for us to work with.

Happy to help : )

[Shivani1195]

this is the text file

[gabrielvilella]

Hi @Shivani1195, you need to read the file as fixed width. When you drop the file into the canvas, select this option:

Then you have to click on the position where each field content ends.