Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Compare Names between tables

Hello All,  I have 2 tables with Names of People.  Table 1 Name  John Max Marry Hilton Mark Chris Leo Table 2 Name John Max Lee Daniel Oleg Swetha both of the tables contai...
Need Help
  • v-jingzhang's avatar
    v-jingzhang
    4 years ago

    Hi Anonymous

     

    What is your expected output in the table visual? If you only want to know which names only exist in Table 1 and which names only exist in Table 2, we just need to compare name values in Name column of each table and don't need to use other columns. 

     

    One idea is to add a column in each table to mark "Yes" if a name is only in this table and "No" if it's in the other table too. You can use this column to filter visuals later. 

    Only in Table 1 = IF('Table 1'[Name] IN VALUES('Table 2'[Name]),"No","Yes")


Only in Table 2 = IF('Table 2'[Name] IN VALUES('Table 1'[Name]),"No","Yes")

     

    Best Regards,
    Community Support Team _ Jing
    If this post helps, please Accept it as Solution to help other members find it.

     

     

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

Anonymous , a new table  like

except(Table1[Name], Table2[Name])

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi Amit, 
Thanks for your Prompt reply. 
what if both of the table do not contain the same amount of columns?
BTW I tried your solution as a measure on a table visual. 
I should have mentioned that Table 1 and Table 2 contain more than just "Name" column and the amount of columns in each of those tables differ from one another. 

 

BR,

Kris