Batch Processing Fixed Width Text Files to Excel

More
4 years 4 months ago #19178 by cchavez
I have been able to read in a single fixed width text file and convert it into an excel spreadsheet and it works great. I have 40 of these text files that all have the same layout that I would like to batch process so I don't have to do every individual file.

I was thinking I could have two readers one for the file directory and the other for reading in a fixed width text file but that doesn't look like a solution with the reader objects.

Given this use case to read in a directory of fixed width text files what is the best practice to batch these files into the .xlsx now I am able to transform them?

Please Log in or Create an account to join the conversation.

More
4 years 4 months ago #19181 by admin
Do you want to create one excel file per source or just one big excel file?

Mike
ETL Architect

Please Log in or Create an account to join the conversation.

More
4 years 4 months ago #19183 by cchavez
Ideally, I would like to create one excel per source. A nice to have would be able to create one big excel file.

Please Log in or Create an account to join the conversation.

More
4 years 4 months ago #19185 by admin
This functionality has been here from the day the software was created.
To create one excel file from multiple text files specify the mask.

To create one file from one source file use examples provided within default repository
Dynamic Files Names 1 - Dynamic Files Names 2

Mike
ETL Architect

Please Log in or Create an account to join the conversation.

More
4 years 4 months ago #19186 by cchavez
Thanks I apologize where are the default repository - Dynamic Files 1 & 2? I see a demo repo that gets installed.

Please Log in or Create an account to join the conversation.

More
4 years 4 months ago #19187 by admin
Here it is


Mike
ETL Architect
Attachments:

Please Log in or Create an account to join the conversation.