Cant fetch the .Txt file using delimiters

[Sameer_Kanade8810]

Hi All,
I have a txt file where the data has blank as delimiters but there are multiples blank lines in between as well.

1.At the top I have a date 
2. My Headers details start from line 5
3. My Line 6 is blank line
4 . My Main data starts from line 7

Below is just a rough sample

12/12/203

                            Name Date CLass

                             Sam 12/11  A

I tried using the space delimiter and tried to import the file but unable to process it. Its still give me error .
Any help help will be really appreciated.

[cjaneczko]

Try setting up your configuration as follows. Don't put any delimiter in and start your import on line 5. Once you have the file imported into Alteryx, use the Text To Columns tool and set it to 3 columns. Then add a dynamic rename tool and set the configuration to pull the name from the first row of data. You can then add a select tool to get rid of the first field.

[TimN]

There is a way to create a map to use on import that really helps if the data is columnar.  See the attached picture.

[TimN]

here's a WF sample