Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

Alteryx Designer Desktop Discussions

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

conditional flow based on Input Value

LuckyRaju
7 - Meteor

I need to continue the flow based on column value.  Based on the column value i need  to different operations. 

Column  name is not always " Continue" .  It can be any name.  It will be created dynamically.  

 

Record IdContinue
1Yes

 

Record IdStart
1Yes
3 REPLIES 3
PhilipMannering
16 - Nebula
16 - Nebula

Will it always be the sceond column? If so, you could rename the second column (Union with headers based on position OR Dynamic Rename based on position) and then use that column name downstream of the workflow.

Yoshiro_Fujimori
15 - Aurora

Hi @LuckyRaju ,

I tried to put the name of the 2nd column into the row value as below. I hope it helps.

 

Workflow

Yoshiro_Fujimori_0-1686906768725.png

 

Output

Yoshiro_Fujimori_1-1686906854556.png

 

Sample operation (Formula tool) using the column name

Output = 

IF [Operation Type] = "Continue"
THEN [Record Id] * 10
ELSE [Record Id] * 2
ENDIF

ed_hayter
12 - Quasar

ed_hayter_4-1686907072807.png

 

I've tried to make something in the most basic case to start:

Input:

ed_hayter_1-1686906706351.png

I made a macro with field mapping turned on:

ed_hayter_2-1686906726955.png

In macro input configuration the ticked check box.

 

We then have the option when running the macro to specify the field that determines whether to use the value or not making a drop down that you can pick the value that means use (in this case yes). then you can specify which field determines path in the field map. Which sends the appropriate rows down their appropriate path.

 

it would then look like so when configuring

ed_hayter_0-1686907163344.png

 

 

Note for populating the drop down if the value to run on has a space or special character when we create the structure to populate the dropdown with the summarize and crosstab we will likely need a dynamic rename to take the name from first row of data to ensure that the value is correct to change.

 

You can open the macro in the packaged workflow with a right click and around third from bottom should be open macro

 

 

 

Labels