We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
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