Hello Experts:
I need some assistance with modifying/extending a *sample* workflow that uses a standard macro.
Allow me first explain the concept -- see attached XLSX file and reference 1st tab 'Single_Workflow':
- User selects "Box Size" (cell D2)
- Column F ("Number of Boxes") is updated accordingly
This XLSX concept is replicated in Alteryx:
- Workflow "Single_Workflow_v01" utilizes standard macro "Macro_Single_Workflow_v01"
- Upon opening "Single_Workflow_v01", highlight the macro and select either {3, 6, 12} from "Select Box Size"
- Then "Run"
- Just like in Excel, depending on the value selected from the drop-down, the "Number of Boxes" calculated in Alteryx mimics the calculation in Excel
... so far so good
Now, let's review the 2nd tab in the XLSX file (tab 'Multiple_Workflows'):
- Here, the previous process (call it "Phase A") is the same.
- Now, however, I have added another factor ("Factor X")... "phase 2"
- Once a value is selected from the drop down {7, 8, 9}, "number of boxes" is multiplied by factor X and the output is shown in column J.
Just like before, I want to replicate the 1st AND 2nd phase in Alteryx:
- The key, however, is that I would like (for demo purposes only right now), to create two (2) separate standard macros.
- Specifically, the 2nd standard macro now needs to take the macro 1's output and input to macro 2.
... and this is where I'm having trouble.
Recap:
- File "Multiple_Workflows_v01" shall use
- Macro "Macro_Multiple_Workflows_PhaseA_v01" AND "Macro_Multiple_Workflows_PhaseB_v01"
- Once the IO is resolved in the 2nd macro, I merely want to have a) Text Input b) Macro_Phase_A, c) Macro_Phase_B, and d) Browse
Does anyone have a suggestion how to resolve the IO issue between the 2 macros?
Thank you,
Tom
