hello! i have a question, is it possible to place a reference page on a workflow to complete some formulation. i attempted a join but the reference page does not have fields to link. i attempted a sample workbook on Excel and the formulas i currently use. sheet 1 is the output on alteryx and sheet2 is the data input in the workflow.
TIA!
Solved! Go to Solution.
You can use join multiple tool for this so that it does a full join. Here is how you can do it.
Workflow:
Hope this helps : )
@atcodedog05 yes this worked! but if comparing more than one condition, such as city and state, the formula would have to carry an AND statement?
such as: IF [City] AND [STATE]=[Input_#2_City] AND [Input_#2_State] THEN "True" ELSE "False" ENDIF
Formula would be
IF [City] = [Input_#2_City] AND [STATE] = [Input_#2_State] THEN "True" ELSE "False" ENDIF
Hope this helps : )