Forum Discussion
Post PatronCombining 2 tables based on unique values
Post PatronDangar332 Ive tried your option but it returns an error that the function EXCEPT doesn't support the joining of a column fromt the type TEXT with a column with the type INTEGER
Resident RockstarHi, RonaldvdH
For combining two tables you have same column type in both tables
Here you got error because of one of your table's column is integer and another table's column type is text
So make sure both tables has same type of column that you want to merge
- RonaldvdH
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
hi, RonaldvdH
yes, it possible just compare it with search code like belownew 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
- RonaldvdH
Dangar332 maybe I need a differnt approach ....
I can summarize both tables based on your formula but then I only have 1 column with SearchCodes (Unique values from both Table A and B)
But then I only have that column but I need the other columns as wel.
However this formula just checks values in table A but what I need is a formula that first searches table A and if that returns a blank then checks table B.
Can I change the varStreet formula so that it doesn just that ?
Straatnaam = VAR varSearchCode = Test[Searchcode] VAR varStreet = FILTER(ALL('Adressen'),Adressen[Searchcode] = varSearchCode) RETURN MAXX(varStreet,Adressen[straat])