Forum Discussion
Helper IIPower Query - Merge
Hi-
I have below question and not sure the answer. My answer is selected both division and roles as join key, and the join kind can be left join..But actually I dont understand the question well that it requires to remove duplicate rows..
Can anyone help on this? Thanks!
There're two Microsoft Power BI queries named Employee and Retired Roles.
We need to merge the Employee query with the Retired Roles query. The solution must ensure that duplicate rows in each query are removed.
Which column and Join Kind should you use in Power Query Editor?
Before merging:
-
In both
EmployeeandRetired Rolesqueries, select the columns you care about (Division + Role) ➔ Remove Duplicates (Home tab ➔ Remove Rows ➔ Remove Duplicates)
Merge:
-
Merge
EmployeewithRetired Roles -
Join on
DivisionandRole -
Join Kind: Left Outer Join (all from Employee, matching from Retired Roles)
Did I answer your question? Mark my post as a solution! Appreciate your Kudos !!
-
4 Replies
- johnbasha33
Super User
Before merging:
-
In both
EmployeeandRetired Rolesqueries, select the columns you care about (Division + Role) ➔ Remove Duplicates (Home tab ➔ Remove Rows ➔ Remove Duplicates)
Merge:
-
Merge
EmployeewithRetired Roles -
Join on
DivisionandRole -
Join Kind: Left Outer Join (all from Employee, matching from Retired Roles)
Did I answer your question? Mark my post as a solution! Appreciate your Kudos !!
-
v-echaithraCommunity Support
Hi New_worker
As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided for the issue worked? or Let us know if you need any further assistance?
If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.Regards,
Chaithra.- v-echaithra
HI New_worker ,
We wanted to kindly follow up to check if the solution provided for the issue worked? or Let us know if you need any further assistance?
If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.Regards,
Chaithra. - v-echaithra
Hi New_worker ,
As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided for the issue worked? or Let us know if you need any further assistance?
If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.Regards,
Chaithra.