LookUp In PowerQuery

[JessyMG27]

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

[watkinnc · Accepted solution]

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

[HotChilli]

A misunderstanding seems to be happening here.  My previous post is the answer, not another question

[JessyMG27]

Apologies!

Thanks you so much it worked!

[HotChilli · Accepted solution]

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

[JessyMG27]

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]

What fields did you merge on?

Can you show a screengrab of the merge screen please?

[JessyMG27]

I did index=key:

[watkinnc · Accepted solution]

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

[JessyMG27]

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