This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
In that case, since the schema is identical between sheets, the Directory Tool -> Dynamic Input tool is exactly what you're looking for. If you could provide a screenshot, or a description of the configuration you have set up, and I can likely help you debug the issue.
Here's a screenshot of what your setup should look like.
I've created 5 files with the same headers as you, and just 1's as the only row as sample data (but this shouldn't matter, the important part is that the column names are the same in all files).
Here's a screenshot:
There's two parts to this workflow:
1) Directory: You'll want to point this towards the directory your excel files are in, and if there are any other files in that folder, change the "File Specification" configuration to match the ones you want to be read. I've set it to "*.xlsx" which will read all excel workbooks. The "*" acts as a wildcard meaning "anything"
2) Dynamic Input: First, select one of your workbooks as the Input Data Source Template. It is important that all other sheets have the same column names as this template. Then, you'll select "Read a List of Data Sources", choose the "FullPath" field, and change the "Action" configuration to "Change Entire File Path".
This should allow you to read in all files in that folder, as desired.
Let me know if this workflow doesn't work for some reason, or there's some complication I've missed.