adding a reference page

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!

Book2.xlsx

Tips and Tricks

Join

Accepted answers

atcodedog05

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

reference.yxmd

All comments

atcodedog05

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

reference.yxmd

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

Quick Links

This months top contributors

AkimasaKajitani 387

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335