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