Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

Duplicating the records while doing leftouter join

Hello ,

Below is 2 tables - 

table 1 - 

singamsagar_0-1621633138504.png

Table 2 -

singamsagar_1-1621633158641.png


Doing left outer join on  table 1 with  table 2 on file # and brining out release # from table 2. When am expanding am getting this output which is wrong-- the records are getting duplicated with release #'s with 14 records. Actual out put should be in 3rd screen shot should be 7 records the release # are duplicating . Please advice.

singamsagar_2-1621633192676.png

 

singamsagar_3-1621633212476.png

 

2 REPLIES 2
Anonymous
Not applicable

Hello Thankyou for your reply,  Join should be on both File # and TG/Amount then the outcome is coming as expected.

Yes if Join on only File# behaviour is right output is wrong.

jdbuchanan71
Super User
Super User

Why should the first line in your first table be release 273545 and not 273526?  What identifies it as belonging with 273545?  The behaviour you are seeing is exactly how a left outer join on File# only should work.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.