Forum Discussion
Post ProdigyPQ _Lookupvalue
Hi good morning,
Can anyone help me on my PQ, aside from Merge Queries how can I lookupvalue on my table. i want to bring the value of table02 to table01.
Thank you
I agree, using merge queries is the easiest and fastest way to do it. If the value does not match, you can check whether it is due to the following reasons:
- Some values in "activity" column may have invisible leading or ending space strings, resulting in no match on them;
- Some "activity" values do not exist in one of the tables;
- There might be spelling mistakes or typo.
There are several methods to find out or resolve above questions:
- Trim the column to clean extra space strings;
- Use Left Outer or Full Outer join;
- Replace or modify incorrect values;
- Use Fuzzy match Fuzzy merge - Power Query | Microsoft Learn
6 Replies
I agree, using merge queries is the easiest and fastest way to do it. If the value does not match, you can check whether it is due to the following reasons:
- Some values in "activity" column may have invisible leading or ending space strings, resulting in no match on them;
- Some "activity" values do not exist in one of the tables;
- There might be spelling mistakes or typo.
There are several methods to find out or resolve above questions:
- Trim the column to clean extra space strings;
- Use Left Outer or Full Outer join;
- Replace or modify incorrect values;
- Use Fuzzy match Fuzzy merge - Power Query | Microsoft Learn
- Deku
Super User
Why do you want a alternative?
AllanBercesHi Deku Coz I try to merge, but there are some hours didnt captured, activity are both on each table. Maybe theres another wa aside from merge
- Deku
With table.join() you can specify joinKind. The default is a inner join but sounds like you want a left outer join to return all of the left table, and returning results where they appear from the right table, else returning null if no matches are found. If so use joinKind.LeftOuter
v-saisrao-msftCommunity Support
Hi AllanBerces,
May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.
Thank you.
- v-saisrao-msft
Hi AllanBerces,
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank you.
