Best way to create a Key Table from 2 columns

[ballist1x]

Hi, i have 2 tables of data, they both contain the names of Manufacturers, and i need to create a Manufacturer Key table as they both share 90% of the values but i need to get the other 10% into this column.

i tried to do it in Dax but there are either blanks or issues with Cardinality that i just cant fix.

How can i do this best in M so that i have  a deduplicated table that i can use as a key between the original two tables?

[v-shex-msft]

HI @ballist1x,

I'm not so clear your scenario, if you can please share some sample data with expected result so we can test on it.

How to Get Your Question Answered Quickly

Regards,

Xiaoxin Sheng

[Stachu]

I'd do the following 1) make sure the tables share names of the columns 2) reference first table as a new query 3) append second table to the query from step 2) 4) remove duplicates based on the key column in table from 3) if the tables do not share the column names you can i) reference and rename them in a single query ii) append only the previous steps (you would need to do the reference manually) iii) deduplicate the key in the appended table