Forum Discussion

Arial12's avatar
Arial12
Frequent Visitor
7 years ago

Case like statements - Compare two table columns

Hi Experts,   I have two table with similar column that i want to compare and calculate a column.   something like this,   if tabl1.col1 = tabl2.col1 then "yes" else "NO"   any suggestion?  ...
Need Help
Arial12's avatar
Arial12
Frequent Visitor
7 years ago

can't merge them. both are very large tables

Christann's avatar
Christann
Icon for Advocate IV rankAdvocate IV
7 years ago

Try creating a relationship between the tables and then use a function like:

isequal = IF(Table[Column1]=RELATED(Table2[Column1]),"yes","no")

Hope this helps!

  • Arial12's avatar
    Arial12
    Frequent Visitor
    7 years ago

    Tables don't have a relationship.

    • dedelman_clng's avatar
      dedelman_clng
      Icon for Community Champion rankCommunity Champion
      7 years ago

      Then how do you know which values to compare?

      • Arial12's avatar
        Arial12
        Frequent Visitor
        7 years ago

        Each table has a column with a matching value with each other..

    • Christann's avatar
      Christann
      Icon for Advocate IV rankAdvocate IV
      7 years ago

      As far as I know, you will have to create a relationship between the tables in order to compare between them. This may require creating an extra column on each of them to use as a link.