Forum Discussion
LOOKUPVALUE
in merge queries, you can merge on multiple columns.
just click CTRL btton while selecting the columns you want to merge on,
hope this helps.
Hi butterscotch
In Power Query editor, Marge table as new and use join kind Full Outer (all data from both table)
Let me know if that works for you
If your requirement is solved, please mark THIS ANSWER as SOLUTION ✔️ and help other users find the solution quickly. Please hit the Thumbs Up 👍 button if this comment helps you.
Thanks
Pijush
Linkedin
this is the result when i merge both tables
as you can see, the table only retrieve the 1st value from norm , if and only if the merging action allow me to select 2 columns that can be used to match these values
in merge queries, you can merge on multiple columns.
just click CTRL btton while selecting the columns you want to merge on,
hope this helps.
Daniel29195 , omg it works ! thank you so much !
