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 Name | Physician 1 | Physician 2 |
Jacob | Dr A | Dr X |
Jacob | Dr B | Dr Z |
Jacob | Dr C | Dr P |
Mike | Dr X | Dr A |
Mike | Dr Y | Dr B |
Mike | Dr Z | Dr P |
David | Dr A | Dr W |
David | Dr Z | Dr X |
User | Count |
---|---|
60 | |
24 | |
24 | |
21 | |
21 |