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 Id | Continue |
1 | Yes |
Record Id | Start |
1 | Yes |
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.
Hi @LuckyRaju ,
I tried to put the name of the 2nd column into the row value as below. I hope it helps.
Workflow
Output
Sample operation (Formula tool) using the column name
Output =
IF [Operation Type] = "Continue"
THEN [Record Id] * 10
ELSE [Record Id] * 2
ENDIF
I've tried to make something in the most basic case to start:
Input:
I made a macro with field mapping turned on:
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
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