cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper IV
Helper IV

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
Highlighted
Community Champion
Community Champion

Re: Merging Query in increasing rows

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!
Ricardo

Highlighted
Helper IV
Helper IV

Re: Merging Query in increasing rows

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.

Highlighted
Community Champion
Community Champion

Re: Merging Query in increasing rows

@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!
Ricardo

Highlighted
Helper IV
Helper IV

Re: Merging Query in increasing rows

I do not have the option to do that here.

Highlighted
Community Champion
Community Champion

Re: Merging Query in increasing rows

@syasmin25 ,

 

You can use GoogleDrive/OneDrive/DropBox.


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

Highlighted
Helper IV
Helper IV

Re: Merging Query in increasing rows

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

Helpful resources

Announcements
August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

Super Users of the Quarter - Q2 2020

Super Users of the Quarter - Q2 2020

Who are our Super User Superstars? Who made it to the top of the leaderboards? Get the answers!

Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Community Summit Australia – Join Online!

Community Summit Australia – Join Online!

Be a part of the leading Microsoft Business Applications digital event, curated for the APAC community.

Top Solution Authors