Forum Discussion
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.
I have another table that consists of all the discipline names and the key
How do I make the first column look at the table above and change all the numbers to the actual text.
Each row in the first table is a response, so I need each response instead of showing a numeric value to show the discipline name that is stated in the second table above.
Not sure if its just a matter of a custom column
If anyone could help please!
Many thanks in advance
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
8 Replies
Hi Nate, many thank for replying,
I tried doing that when but when i merge and expand it only just copies and pastes the discipline column as it is.
So in the second column in the image above the first reponse '56' should be "Chemistry -Chemistry" and the second response which is '115' should be "Business and Management - Human resources management
- HotChilli
Community Champion
What fields did you merge on?
Can you show a screengrab of the merge screen please?
I did index=key:
- HotChilli
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
- HotChilli
A misunderstanding seems to be happening here. My previous post is the answer, not another question
Apologies!
Thanks you so much it worked!
