Duplicates when merging tables in Power BI

[Analitika]

Hi,

I would like to ask  how to merge tables properly because now I am getting duplicates.

I wanted to join table when one column matches other column in second table.

First table, column OBJ_KOD, 

second table:

Column Obj,

So I used left outer join OBJ_KOD Obj. then got table with duplicated rows. I expected that I will add column value when obj_kod matches obj kod other will be null. So how resolve this issue?

[PC2790]

Hello @Analitika ,

If you are looking to get only the matching values, you should look to go for inner join.

You can assess your requirement and then decide the type of join you want to use.

A very nice article explaining the different types - here

[Analitika]

Before merge:

After duplicate:

[Analitika]

Before merge table:

Merge:

After merge, gettting:

Many duplicates

[PC2790]

can you share the M code from power query editor?