Forum Discussion
LOOKUPVALUE
Hello everyone!
im facing an issue with LOOKUPVALUE , where it only return the first matching value but i have multiple data (project)
this is the 1st table:
this is the 2nd table:
this is the expected output:
Can anyone help me ? thank you in advance!
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.
4 Replies
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
Linkedinthis 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.
