adding a reference page

[utsarunner981]

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!

[atcodedog05 · Accepted solution]

Hi @utsarunner981 

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 : )

[utsarunner981]

@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

[atcodedog05]

Hi @utsarunner981 

Formula would be

IF [City] = [Input_#2_City] AND [STATE] = [Input_#2_State] THEN "True" ELSE "False" ENDIF

Hope this helps : )