Alteryx Designer Desktop Discussions

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

=IFERROR(VLOOKUP(A2,Act!A:I,9,FALSE),VLOOKUP(Tracker!A2,Com!A:G,7,FALSE))

Kinetic_analytics
11 - Bolide

Hello great people:

I need help to transform this Excel formula into the Alteryx workflow.

Appreciate your help.

 

Thanks

3 REPLIES 3
pcan415
Alteryx Alumni (Retired)

Hi @Kinetic_analytics,

 

We should be able to use a join tool to accomplish this, configure the tool to join on Case ID. I have included a screenshot. Let me know if this helps.

 

 

Kinetic_analytics
11 - Bolide

Thank you. Appreciate your help. 

Kinetic_analytics
11 - Bolide

Thank you.

Labels