Dynamic detection of tabs in Excel spreadsheet

Archaeopteryx

Hi,

Using version 2018.2 of Designer -- 

I have an Excel spreadsheet with multiple tabs. Additional tabs may be added depending on the current quarter's reportings. 

Without having to adjust the workflow to introduce new tabs, can Alteryx detect the tabs automatically and proceed with the workflow process? 

Thanks,

Chris

NickSm

Hey @Archaeopteryx 

There's a couple dynamic ways to read in all / new sheets.  You can use an input tool and instead of specifying a specific sheet, select the radio button for "Read in List of Sheets", then follow this with a Dynamic Input which will read in all of those sheets.

There's also a nifty macro out there for doing something similar:

https://community.alteryx.com/t5/Engine-Works-Blog/The-Ultimate-Alteryx-Holiday-gift-of-2015-Read-ALL-Excel-Macro/ba-p/9988