Dynamic Run Using a Control Book in Excel

Question

I've created the following workflow to do a transpose and multiple tables, but the tables are hard coded in and I would like more flexibility. I am wanting to add a Control worksheet in Excel that Alteryx will read.

If the Active? column has a 'Y' I'd like it to Query the table from the corresponding Table column. I also want Alteryx to be able to adjust to having more than or less than 6 inputs automatically. i.e. Only using Tables A-C so the workflow adjusts to being only 3 streams tall.

test.xlsx

Control.yxmd

SPetrie · Accepted Answer

How about something like this.

Import your control sheet and then import a list of sheet names. Filter to only active=y and joining it on the sheet names. That will give you the list of sheets that are active. Feed the full paths of those to a batch macro to import them and then do whatever transformations you require after that.