Forum Discussion

speedramps's avatar
speedramps
Super User
4 years ago

You have records with duplicate "Bus_OBJKEY"  keys on table  "1Head".

See attached screen print.

 

So the join is retreiving multiple records.

 

It is simple to fix.

 

In Power Query sort  table  "1Head" by "Bus_OBJKEY"

Then remove "Bus_OBJKEY" duplicates.

 

Now so the join, and it should work as desired.

 

Thanks for reaching out for help.

I have helped you, now please help me by giving kudos.

Remeber we are unpaid volunteers.

Click the thumbs up and accept as solution button. 

One question per ticket please. If you need to extend your request then please raise a new ticket.

You will get a quicker response and each volunteer solver will get the kudos they deserve. Thank you !

 

 

 

Matas's avatar
Matas
Advocate II
4 years ago

Hi, 

 

Thanks for your answer. 

I did have removed Bus_OBJKEY Duplicates from the 1Head table. So now when I am merging tables and expanding their Document ID I am getting 600k+ thousand instead of 38,843 results. So I believe that your suggestion did not solve my initial issue. Do you have any other ideas? It would be highly appreciated.