Start Free Trial

Alteryx Designer Desktop Discussions

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

How to Do If the value in Column A matches with Column C in a different row

gowriangry
5 - Atom

How to Do If the value in Column A matches with Column C in a different row, then show the value in Column B based on Column C, otherwise show null

 

Column AColumn BColumn COutCome Like
nullApplerec-1null
rec-4Bananarec-2Carrot
rec-6Pomorec-3France
rec-5Carrotrec-4Elaki
rec-10Elakirec-5Berry
rec-5Francerec-6Elaki
rec-4Greecerec-7carrot
rec-7Himachalrec-8Greece
nullOrangerec-9null
nullBerryrec-10null
1 REPLY 1
messi007
15 - Aurora
15 - Aurora

@gowriangry,

 

Please see blow how you can do that 

 

Capture.PNG

Attached the workflow,

Regards

Labels
Top Solution Authors