How do I convert text file with report headers on multiple pages into the right format

I'm a recent new user of the tool. I tried to input a text file (read it as fixed width text file) to get it into a format like excel where I can use Alteryx to vlookup (join tool) with another input table. The text file has the report headers and dotted lines on multiple pages, I don't know how to get rid of these so that I can get the below output to run further analysis.

Item	Description	Class	UOM	Sequence	Quantity	Usage Value
00-30430Z	LEMO CONNECTOR	C	EA	643	0	0
000-0450-23	Motor, Blower, Maxi-Tube II	B	EA	100	8245	338532.18

Original Text File and output.docx

Tips and Tricks

Accepted answers

Maskell_Rascal

Hi @BC_O

Thank you for providing a sample file. Try the attached packaged workflow. I created a FLAT file template that splits you data into fixed width columns. From there, there was a lot of filtering and parsing that needed to be done to get the data into a usable format, but the final output looks like this:

Hope this helps.

Cheers!

Phil

Import Text File Multiple Pages and Headers.yxzp

All comments

Maskell_Rascal

@BC_O

Can you provide the actual .txt file? It would make it a lot easier to trouble shoot and find a solution if we know the structure of the data going in.

Thanks!

Phil

Watermark

This seems like you need a number of steps. Bring it in as a text, all the info in one field, skip the first number of lines, then start to parse or regex it out. Could need a couple of steps to do it, but like the last poster commented. If you post the actual sheet, there are people here who could split it out.

BC_O

This is the actual text file. Because of data confidentiality, I switched to another smaller text file in similar format and replaced some sensitive data.