Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi ,
i am trying to merge three tables using a left outer join ( first i merged first two tables using a left outer join and then did merge with third table with left outer join) - the master table contained unique matching records but the other two tables duplicate entries so i did left outer join (1:m relantionshop)-- now this is causing duplicates. Can you help as how to resolve this ?
Solved! Go to Solution.
Hi @RUPSY777
what do you want to achieve?
Maybe it will be enough to just put columns into visual without additional joining?
thanks it got solved by choosing the aggregate function in expansion for merge join.
thanks it got solved by choosing the aggregate function in expansion for merge join.
Hi @RUPSY777 ,
Glad to hear that. You may help accept your reply above as the solution. Your contribution is highly appreciated.
Best Regards,
Icey
User | Count |
---|---|
77 | |
77 | |
68 | |
67 | |
49 |
User | Count |
---|---|
108 | |
105 | |
93 | |
83 | |
64 |