Forum Discussion

RonaldvdH's avatar
RonaldvdH
Post Patron
2 years ago

Combining 2 tables based on unique values

I have a question and I need to combine 2 datasheets (2 different tables) based on unique values is both columns. Both tables have the column with the unique value SearchCode and however 95% of the ...
Need Help
RonaldvdH's avatar
RonaldvdH
Post Patron
2 years ago

That did the trick but the new table has duplicate rows so how do I just get the unique values ?

 

Edit: the SearchCode is in both tables the same but some columns have a different value in table B then it has in table A and viceversa. Is it possible for the EXCEPT to just check based on the SearchCode ?

Dangar332's avatar
Dangar332
Resident Rockstar
2 years ago

hi, RonaldvdH 

yes, it possible just compare it with search code like below

new table=
var table_1 = SUMMARIZE(Table1,Table1[search code])
var table_2 = SUMMARIZE(Table2,Table2[search code])
var result = EXCEPT(table_2,table_1)
return
UNION(table_1,result)

 

it give only join of search column

 

if you still not get your answer then provide some sample data and expected output