Forum Discussion
Solved
LookUp In PowerQuery
I have a column that looks at the responses students have given to the question ' What is your discipline?' Each numeric value is is a discipline. E.g. 56 = Medicine, 115 = Dentistry etc. ...
You could just use the Merge menu to do a Nested Left Outer Join on Index = Key, and then expand just the Disciplines text column.
--Nate
From your original post - "Each numeric value is is a discipline. E.g. 56 = Medicine, 115 = Dentistry " so you want to merge on Q33-discipline and key
From your original post - "Each numeric value is is a discipline. E.g. 56 = Medicine, 115 = Dentistry " so you want to merge on Q33-discipline and key
Yup thats right, so each numeric value in the Q33-discipline should be text and the text would be the name of the discipline that, that student is in
