I have a parent folder. Within that parent folder, there are multiple folders and within that folder, I have to extract all the sheets data into one big dataframe
This is what I mean:
Parent Folder - Multiple folders - Multiple Sheets- Different Schema
Within these excel files, there are multiple sheets.
e.g.
I want to extract all the sheets within one table with a column containing full sheet path so that i can then union the respective sheets to create a master information for "Contractor A", "Contractor B", "Contractor C", etc.
I have got the file names. Now, I am aware of this example that can read multiple sheets however, every sheet has a different structure and different columns with a very few common columns and column types and thus, I am getting error when I use the Dynamic input tool.
How can I get what I want?
@HW1
The data scheme/struture can be different but I observe that the data starts from Row#1 and some starts from #2. That imposes the issue.
Anyway, I used the famaous macro for inputting multiple sheets in multiple files and getting something.