1 Reply Latest reply: Mar 2, 2017 3:24 AM by Ali Hijazi RSS

    How to compare two tables

    Ram Krishna

      Hi,

       

      Can anyone please help how to compare two table in qlik and only load not matching rows as shown in below table.

       

      Table1:

      Table1.PNG

      Table2:

      Table2.PNG

       

      Desired Result:

      Table3:

      Table3.PNG

       

      Thanks,

      Ram Krishna

        • Re: How to compare two tables
          Ali Hijazi

          you need to create a key in both tables:

          in table1 Load A, B,C, A & '|' & B & '|' & C as Key1

          in table2 NoConcatenate Load A,B,C, A & '|' & B & '|' & C as Key2

           

          finally:

          Table3:

          noConcatenate

          load A,B,C

          resident table1 where not exists(Key2,Key1);

           

          drop tables Table1, Table2