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
syasmin25
Helper V
Helper V

Merging Query in increasing rows

Hello, 

I am trying to merge two tables to get 3 columns from the other table and it is creating 4 additional duplicate rows (in the actual report, which has led to more than 2 million rows). I have created a sample here and it even did the same thing to that. I was wondering if somebody could help me out here. I am doing a left outer join and have made sure that the tables do not have duplicates beforehand. 

I am attaching screenshots of my sample file here, 

Attendance Table:tbruh.PNGClasses Table:
tbruh.PNG

 Merge Tables tbruh.PNG

 

 

 

6 REPLIES 6
camargos88
Community Champion
Community Champion

Hi @syasmin25 ,

 

Are you merging them with unique id's per row ?

If not they are gonna replicate the rows from the outer table.

 



Did I answer your question? Mark my post as a solution!

Proud to be a Super User!



In the original file, I have created a ID.Bellperiod index column in both the tables and I am trying to merge based on that.

@syasmin25,

 

Can you share a sample of it on a PBIX ? 

So we can take a look.



Did I answer your question? Mark my post as a solution!

Proud to be a Super User!



I do not have the option to do that here.

@syasmin25 ,

 

You can use GoogleDrive/OneDrive/DropBox.



Did I answer your question? Mark my post as a solution!

Proud to be a Super User!



I figured it out. It was an issue within the database.

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.

Top Solution Authors
Top Kudoed Authors