Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It 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 |
---|---|
106 | |
90 | |
82 | |
76 | |
73 |
User | Count |
---|---|
112 | |
101 | |
96 | |
74 | |
67 |