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