Text to columns

Question

Hello I have a file, which is txt file. The issue if that I would like to read the latest file from the folder and have it done as text to columns.

It was always done in Excel and I wanted to follow the same logic in Alteryx but the issue if that Alteryx moved rows to left when I load that to Alteryx:

Is there a quick way to solve the following:

1. I want the process to choose the latest file from folder

2. I use the dynamic input tool

3. Choose tools to make text to columns  based on defined headers - self described

ESL NLSeptember 2022 download - Copy.txt

gautiergodard · Answer

@Kingazawora kindly accept the solution(s) which helped you to make it easier for others with similar issues to find the answer on the future !

Kingazawora · Answer

Many thanks! Works!

TimN · Answer

Hi,

I tried this differently.  Seems like there were special characters in the file so I tried stripping them and then used a File\Field layout.

ESL_Cleaned.yxmd