Dynamic Input Using a Excel Control Sheet

To allow for more flexibility, I am trying to use an Control sheet in Excel to import the named tables into Alteryx. The _L tables must go to the top stream while the _G tables must go to the bottom stream, but AL & AG must join at the end. There cannot be any crossing between tables i.e AL & BG.

test.xlsx

Control.yxmd

Duplicate&Replace.yxmc

Workflow

Macros

Dynamic Processing

Accepted answers

All comments

binu_acs

@mquast Can you elaborate more about your requirement? Where are the L and G tables in the input file?

mquast

So in the inputs tab there are 14 different tables each with their own specific name. Each class, A,B,C,..,G has 2 tables associated with it. Example AL & AG belong to Class A. BL & BG belong to Class B and so on.

What I am trying to do is have an Control Worksheet that will allow me to select certain Classes to use. So if I only want Class A & C, I need Alteryx to only query table AL, AG, CL, and CG. Currently I have a hard coded version that queries each table, but I need a more flexible option.

The workflow also needs to do the transformation to AL & AG and join those before it does the transformation to CL & CG and joins those. So if we think of the workflow as a stack, it must be in alphabetical order reading top down.