Need help bringing in 12 sheets from 1 Excel file with same schema / 2 sheets diff schema

[slaurel]

Hi community! 

I am struggling with this file right now and could really use some help. I have an Excel file that has 14 total tabs. I only need 12 of them (all the same schema), BUT 2 of the other tabs that I do not need in it are a different schema, so my dynamic input skips all 12 of my files and I can't get it to work. I cannot delete the other 2 tabs because the 12 tabs I need reply on those tabs via formulas. I tried filtering the sheet names right after my original input (<List of sheet names>), but that did not work either. 

In each of the 12 tabs, I only need the range A93-J130 (Row 93 being the column headers). 

Can someone please mock up a small workflow that takes this in and spits out the right stuff?

I need tabs J, F, M, A, M, J, JU, AU, SE, O, N, D. I do not need the "Total" or "Year" tabs to be brought into the workflow. 

[aatalai]

You can try the dynamic input, as you said the 12 you want have the same schema. So use the input tool to bring in sheet names and then filter out the 2 you want. Set up the template in the dynamic input tool to bring in the data range you want.

Let me know if this is of any help

[aatalai]

Sorry didn't see you say you tried that before. Then I would sugegst a batch macro

take a look here too https://knowledge.alteryx.com/index/s/article/How-To-Import-Multiple-Excel-Sheets-or-a-Specific-Exce...

[slaurel]

@aatalai I already tried that and it did not work. I used a regular input, selected "<List of Sheet Names>, then filtered out the sheets I do not want, then connected that to the dynamic input. 

Edit: just saw your updated response. Let me try that and I will get back to you. 

[aatalai]

@slaurel does that include my second post with the link?

[slaurel]

@aatalai It says that in order for it to work, all sheets in the file must be the same schema

[aatalai]

Hmmm interesting ok try this youtube video

https://www.youtube.com/watch?v=z-iTDI5lD00

unfortunately i'm away from alteryx otherwise would have mocked something up

[Raj]

@slaurel you can use this macro

[slaurel]

@Raj This is not what I am looking for. That takes a directory and reads in various files + their sheets. I have only one file with multiple sheets. Not all of them are the same schema. 

[cjaneczko]

Raj's macro will do what you are looking for once you have the list of sheet names filtered from an input tool. It will pull in each sheet. I currently use this to do exactly what you are trying to do.