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.
@mquast Can you elaborate more about your requirement? Where are the L and G tables in the input file?
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.
I'll include the whole hard coded workflow to reference.
@mquast Your workflow is not opening, also can you attach the input file which has 14 different tabs
@binuacs I am trying not to use 14 different worksheets to avoid have a cluster for others. The 14 tables are located under the input worksheet.
@mquast Can you upload your workflow as .zip format(go to menu - Options-export workflow)