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.

Look up a value in a column

KasimIkram
5 - Atom

I am a complete newbie to Alteryx so any help will be much appreciated.

 

I want to find out which patients were seen by Dr A as a 1st physician and as 2nd physician.  

Dr A is the value that I want to search for in column 2 and column 3 but for each patient. Dr A will not be repeated for a patient so Jacob can only have 1 Dr A and Dr A will either be in column 1 or column 2 for a given patient. 

 

Patient NamePhysician 1Physician 2
JacobDr ADr X
JacobDr BDr Z
Jacob Dr CDr P
MikeDr XDr A
MikeDr YDr B
MikeDr ZDr P
DavidDr ADr W
DavidDr ZDr X
1 REPLY 1
JarekSkudrzyk
11 - Bolide

@KasimIkram try using transpose tool and then filter on value:

JarekSkudrzyk_0-1649882919557.png

 

Labels
Top Solution Authors