Fixed width column text files data parsing

[murthybhs]

I get text files that look like this everyday day to run analysis on them.

The width of the columns is the same in every file. Everyday, when I get the file, I use the input tool and select "Read it as a fixed width text file" and manually select the column widths. Is there a way to automate this instead of me selecting the column width every time I try to run my analysis?

Any help in this matter is highly appreciated.

[fmvizcaino · Accepted solution]

Hi @murthybhs ,

You can save the layout after manually selecting the columns widths.

It can be found here: https://help.alteryx.com/current/designer/flat-file-layout

Best,

Fernando Vizcaino