1 Reply Latest reply: Jan 12, 2017 12:09 PM by Gysbert Wassenaar RSS

    Combining tables

    Aviad Bein

      Hi all,

       

      I want to make a comparison between "Sales forecast present data" and "Sales forecast start-of-year data".

      To do so, I got two tables, Table1 (start-of-year "snapshot" data) and Table2 ( present dynamic data):

       

      Table1:

      KeyCustomer
      1TBD
      2A2
      3TBD
      4A4

       

      Table2:

      KeyCustomer
      1B1
      3B3
      4B4
      5B5
      6B6

       

      and i want to merge those two tables to one like this:

       

      Table:

      KeyCustomer
      1B1
      2A2
      3B3
      4B4
      5B5
      6B6

       

      I mean, I want to ignore from Table1.Customer values (historical) if there are present values in Table2.Customer and only append

      Table1 rows that deleted over time (cancelled/aborted deals) to Table2.

       

      P.S - I've already read help.qlik.com and this thread: Understanding Join, Keep and Concatenate

       

      Thanks in advance,

      Aviad