In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

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

If Error - Vlookup

Jaganmohan
8 - Asteroid

Hi - Happy New Year!

Please help me out on this - I need to implement the below logic on the alteryx workflow.

=IFERROR(VLOOKUP(E2,Mapping!A:B,2,FALSE),"No")

Column F logic with mapping file (please find the attachment) - Thanks in Advance.

 

 

2 REPLIES 2
atcodedog05
22 - Nova
22 - Nova

Hi @Jaganmohan 

 

Here is how you can do it.

Workflow:

atcodedog05_0-1642769313988.png

 

Hope this helps : )

 

binuacs
21 - Polaris

@Jaganmohan Simiar to @atcodedog05 solution

binuacs_1-1642769813195.png

 

 

Labels
Top Solution Authors