Import content of multiple txt files

KrisG

Greetings Alteryx community!

Making my first post here, as I am facing a challenge I have not been able to solve.

I have about 100 log files in TXT format with the following schema:

I need to import the contents of all these txt files to get an overview of the logs and the errors thrown ("Status reason"). I have messed around with the standard Input tool and the Directory tool but have not found a way to import all the contents and organize it in columns. All the files have the same scheme although things are slightly more complicated since the number of tabs varies. For instance there is just a single tab after "Excel generate time" but 3 tabs added after "CVR".

Does anyone have an idea on how to achieve this, so I can import and organize the contents of all these log files in columns? 
I am adding a couple of the log files for reference.

Thank you all

10153670-indkomstår 2017-12-10-17_02;27;28.txt

10820871-indkomstår 2017-01-11-17_11;10;23.txt

MarqueeCrew

@KrisG,

I have a workflow to share with you.  Here's my approach:

1. Read Input with a wildcard to get all files
   1. Flat, no delimiter
   2. Keep filename
2. Replace tab(s) with a single '|' pipe character
3. Parse on PIPE
4. Crosstab from columns to rows of data
5. Reformat excel date so that @ 0 becomes @ 00:00:00
6. Convert dates to ISO date formats
   1. Excel
   2. File End
   3. File Start
7. Cleanup

Cheers,

Mark

Import Multiple Text Files.yxmd