3 Replies Latest reply: Jan 20, 2017 9:59 AM by s Walter RSS

    Compare multiple columns

    s Walter

      Hi,

       

      at 1st i load this data. Tablename: tableA

      2017-01-20_10h08_45.jpg

      After that i load this table tableB. In the load script i want to add the column Found...

       

      2017-01-20_10h16_46.jpg

      ...and want to compare the columns Product, SalesNumber, Customer of each record with data from tableA.

      If the value of each column identical, then Found should get the value "x".

       

      How can i do it?

       

      Regards,

      sam