How to build Alteryx flow for if match and lookup

[Learner09]

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

[Jean-Balteryx · Accepted solution]

Hi @Learner09 ,

I think this example workflow  might help you !

Cheers,

Jean-Baptiste

[Hannah_Lissaman · Accepted solution]

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.

[Learner09]

Thanks a lot Jean 🙂

[Learner09]

Thank you Lisa