Alteryx Designer Discussions

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

How to build Alteryx flow for if match and lookup

Mayank09
8 - Asteroid

Hello,

 

I need to add the new column in my Alteryx Model. Please see the details in the attached file and help me.

 

Thanks,

Mayank

4 REPLIES 4
Jean-Balteryx
16 - Nebula
16 - Nebula

Hi @Mayank09 ,

 

I think this example workflow  might help you !

 

Cheers,

 

Jean-Baptiste

Hannah_Lissaman
11 - Bolide

I also made you an example - will share in case the extra one is useful.

 

As a general rule, anything which uses a lookup (e.g. Match, VLOOKUP) in Excel will require you to use a Join in Alteryx.

 

Hannah_Lissaman_0-1589552119458.png

 

Mayank09
8 - Asteroid

Thanks a lot Jean 🙂

Mayank09
8 - Asteroid

Thank you Lisa

Labels