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
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..

      • 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.