Forum Discussion
Attempting to use Merge for a VLookup in Power Query
Very new to Power Query. I want to perform a Vlookup from another workbook.
I saw an old post with a YouTube Link about Merging Queries. But, I can't seem to get it to work.
I have 2 Queries that will be Appended:
I tried to Merge the "Append1" with the "VLookup_Combined", but no matches were found. I know this is incorrect, because I can do a manual VLookup (outside of Power Query), and it works.
What should I be changing?
Can I do this on an Append Table? Or do I need to perform the Merge on each query, before I Append them?
Here are all the files I'm using:
Thanks!
Anonymous ,
Have you tried cleaning both columns with trim/upper|lower function ?
Power Query is case sensitive and blank spaces in the beginning/end matters for merge.
3 Replies
camargos88Community Champion
Anonymous ,
Have you tried cleaning both columns with trim/upper|lower function ?
Power Query is case sensitive and blank spaces in the beginning/end matters for merge.
Aha - That did it! Thank you, had no idea there was a trim option!
For my learning purposes, what is the upper/lower function please?
- camargos88
Anonymous ,
UPPER -> transform all the text to UPPER CASE
LOWER -> transform all the text to LOWER CASE
https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference