13 Replies Latest reply: Oct 9, 2018 4:08 AM by Beck Bakytbek RSS

    compare value within columns

    Beck Bakytbek

      Hi Folks,

       

      i got a question: how can i compare value within 2 columns, i solved a part of my issue by using this expression:

       

      if( column1 = column2, 'yes','no') as compare

      but what if, i want to compare the value which i loaded yesterday with value wich i loaded today and all those values i compare in the form: column1 vs column2.

      For more clarity, please see the attached screenshot.

       

      Does anybody have any ideas?

      Thanks a lot

      Beck