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.
We actually use this kind of problem to demo batch macros and it forms part of our training on this subject.
If this is for demo purposes and you want to simply show off the dynamic input capability, then as you have hinted at, your only options are to ensure every tab has the same schema, then you will be good.
If so, then it's a really straight forward process; the macro should look like the image below. I have highlighted key confiugrations in red...
And here is an example of how that can be intergrated into a workflow (of course you shouldn't use a text input for the paths and instead make a dynamic process, but as mentioned, this is the point at which I Was building from)...
I've attached this simple macro to the post for your benefit.
In order to view the results you MUST have a browse tool on the output anchor, otherwise only one record will come out.
I have a very similar situation except I am trying to consolidate 14 out of the 15 tabs (sheets) into one sheet. I receive the different schema error when I apply the file with the dynamic input. I am trying the batch macro but the output just spit show the 14 sheet name and the browse show no data.
How do I get to one consolidated sheet for the 14 sheets?
Hello- I feel like I'm in a similar boat and I am unclear how to utilize this solution. I have a spreadsheet with 4 tabs, I want to bring those 4 tabs together, but am running into different schema error (which I suspect is stemming from how the field types are coming through). Any suggestions?
You can accomplish this by setting the Input tool to read in the "Import only sheet names" and having the file name as a field. You will then use a Formula tool to format the file name with the sheet name extension as you seen in the Input tool when bringing in one sheet. You will then use Ben's example and have the control parameter update the file name along with the sheet.