how to read the data from multiple unstructured flat files?

[stj1120]

Hi all,

I get the data in multiple flat files which are completely unstructured ones. Each file starts with a common name as 'ZORU_Big-3_' followed by plant number, month and year. 

I'm struggling in reading the data from all the files at once. Also in the input tool configuration if I keep the file name as 'ZORU_Big-3_*.txt' it is not reading all the files. 

I tried using dynamic input but no luck. Also I tried using batch macro, same here. 

Could you help me in reading the data from the files like these by maintaining the proper naming convention of the files while configuring the path in the input tool? Please check the files attached and also the workflow and help me with the solution. Also can we get the data in the proper structured format in the output as columns?

Thank you. 

Best regards,

Teja.

[jrgo · Accepted solution]

You'll still have some work to do, but this should give you a good head start.