3 Replies Latest reply: Apr 10, 2017 3:33 AM by Sander Gardenier RSS

    Understanding concatenate

    Michiel van de Goor

      Hi, if I concatenate 3 tables with the same KEY fields but deviating facts I have the following results:

       

      Loading 10 lines:

      After first table resutl is 10 lines

      After second table result is 30 lines

      After third table result is 70 lines

       

      If I add an additional unique key per table this happens:

      After first table resutl is 10 lines

      After second table result is 20 lines

      After third table result is 30 lines

       

      I'm wondering if I get a doubling of my lines in the first method (and since I load millions of rows that is not preferable.

      QlikView shows unique values only in table box but the table viewer does count 70 rows.

       

      What is really happening under the hood, are there 70 lines that consumes resources? Thanks