Forum Discussion

SteveG_91's avatar
SteveG_91
Helper I
3 years ago
Solved

Compare Two Tables

I have two tables containing application data, Table1 and Table2.  They are related to each other using the common column, APP_NUM.  Table1 has only one row per APP_NUM while Table2 can have 1 or mor...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi SteveG_91  ,

    Try this:

    MATCH = CONTAINSSTRING('Table (2)'[PHONE],RELATED('Table'[PHONE_NUM]))

    Output:

     

    Best Regards,

    Yolo Zhu

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi SteveG_91 

     

    You can try this:

    MATCH = IF(ISBLANK(RELATED('Table'[APP_NUM])),FALSE(),CONTAINSSTRING('Table (2)'[PHONE],RELATED('Table'[PHONE_NUM])))

    Best Regards!

     

    Yolo

Bifinity_75's avatar
Bifinity_75
Solution Sage
3 years ago

Hi SteveG_91 , create this relationship:

 

And create this calculate column:

Match = if(RELATED(Table1[APP_NUM])=BLANK(),"No","Yes")

The result:

 

Best Regards

 

 

 

 

SteveG_91's avatar
SteveG_91
Helper I
3 years ago

So I already have a one to many relationship between these two tables on the APP_NUM and the PHONE and PHONE_NUM would be a many to many since the phone number can appear multiple times on each table.  When I look to see if the phone number is on both tables it has to be specific to the same APP_NUM.  In other words, for APP_NUM 12345 on Table1 I only want to compare the phone numbers to APP_NUM 12345 on Table2.  Then compare the phone numbers for APP_NUM 77777, etc.