Need help bringing in 12 sheets from 1 Excel file with same schema / 2 sheets diff schema
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Labels:
- Dynamic Processing
- Input
- Workflow
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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...
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@slaurel does that include my second post with the link?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@aatalai It says that in order for it to work, all sheets in the file must be the same schema
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@slaurel you can use this macro
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
