topic Re: Merging Query in increasing rows in Power Query

Merging Query in increasing rows

syasmin25 — Wed, 27 May 2020 18:43:14 GMT

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:Classes Table:

Merge Tables

Re: Merging Query in increasing rows

camargos88 — Wed, 27 May 2020 19:32:32 GMT

Hi syasmin25 ,

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

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

Re: Merging Query in increasing rows

syasmin25 — Wed, 27 May 2020 19:41:15 GMT

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.

Re: Merging Query in increasing rows

camargos88 — Wed, 27 May 2020 20:04:56 GMT

syasmin25,

Can you share a sample of it on a PBIX ?

So we can take a look.

Re: Merging Query in increasing rows

syasmin25 — Wed, 27 May 2020 20:43:36 GMT

I do not have the option to do that here.

Re: Merging Query in increasing rows

camargos88 — Wed, 27 May 2020 20:46:08 GMT

syasmin25 ,

You can use GoogleDrive/OneDrive/DropBox.

Re: Merging Query in increasing rows

syasmin25 — Fri, 29 May 2020 20:35:36 GMT

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

Re: Merging Query in increasing rows

Delvirio — Fri, 10 May 2024 08:16:03 GMT

Hi, can you tell me what happened exactly with your database? looks like I have similar issue with you.