Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask here!
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Dynamic Input Using a Excel Control Sheet

mquast
8 - Asteroid

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.

6 REPLIES 6
binuacs
21 - Polaris

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

mquast
8 - Asteroid

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. 

binuacs
21 - Polaris

@mquast Your workflow is not opening, also can you attach the input file which has 14 different tabs

mquast
8 - Asteroid

@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. 

 

Screenshot 2023-07-20 143632.png

binuacs
21 - Polaris

@mquast Can you upload your workflow as .zip format(go to menu - Options-export workflow)

mquast
8 - Asteroid
Labels
Top Solution Authors