Merging issues

[yodha]

i am trying to merge two tables using INNER JOIN but am getting duplicate rows.

This is my data " https://www.dropbox.com/s/2wk5tk455w5332p/Data.xlsx?dl=0 "

am trying to merge these two tables based on these columns:  UNIT,LOC,DATE,MATCH BD from Table 1

                                                                                              and UNIT,LOC,DATE,MATCH ID from Table 2

My final table after merging should be like this: UNIT, GROUP,LOC,PR,DATE,BD,BD Value, MATCH BD, ID, ID value.

Any help on this Please. Thanks in Advance.

[v-juanli-msft]

Hi @yodha 

add merge columns in Table1 and Table2,

(merge columns UNIT,LOC,DATE,MATCH BD to one column)

merge queries for Table1 and Table2 based on" merged1" and "merged2" columns.

select ID, ID value by expanding the "Table2" field

Best Regards
Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[yodha]

Hi @v-juanli-msft 

Its not working, still am getting duplicate rows.

Thank you.

[v-juanli-msft]

Hi @yodha 

Do you download my pbix to see each step?

Or could you share the pbix with me for further analysis?

Best Regards
Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[yodha]

Any help on this?