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 |
Solved! Go to Solution.
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
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.
Thank you, @Maskell_Rascal . I attached the actual text file below.
Thank you @Watermark. I attached the actual text file as below. In the meantime, I will try to read up on parse or regex.
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
@Maskell_Rascal Thank you, it works perfectly. I just need to go through it to understand the flow.