2 Replies Latest reply: Dec 9, 2012 12:54 AM by Mohamed Eshack RSS

    What is difference between add,concatenate,without concatenate?

    Kabilan Kumarasamy

      Hi All,

       

      I have doubt.

       

      We have a script keyword add, concatenate in qlikview. Ryt?

       

      I want to know what is the difference between those.?

       

      I worto a script like below:

       

      Tab1:

      load * Inline

      [Id1,Item

      1,A

      2,B

      3,C

      4,D];

      Concatenate

      load * Inline

      [Id1,Item

      1,A

      2,B

      3,C

      4,D

      5,E] where not Exists(Item);

       

       

      Tab2:

      load * Inline

      [Id1,Item

      1,A

      2,B

      3,C

      4,D];

      Add

      load * Inline

      [Id1,Item

      1,A

      2,B

      3,C

      4,D

      5,E] where not Exists(Item);

       

      Tab3:

      load * Inline

      [Id1,Item

      1,A

      2,B

      3,C

      4,D];

       

      load * Inline

      [Id1,Item

      1,A

      2,B

      3,C

      4,D

      5,E] where not Exists(Item);

       

      These three tables returns same value like below.

       

      Capture12.PNG

       

      Please give me some knowledge on this.

       

      Regards,

      Kabilan K.


        • Re: What is difference between add,concatenate,without concatenate?
          Johannes Sunden

          1. Concatenate does not make any difference here because the table structure of table 1 and 2 is the same (Id1 and Item). Thus, QlikView will concatenate these tables automatically. The concatenate keyword is used to force concatenation of two tables that do not have an identical structure.

           

          2. The Add keyword is used for Partial Reload, so when runing a partial reload, only the load statements with the prefix add or replace will be loaded. However, on a full reload all load statements will run, so in this case both table 1 and 2 load as normal and since the structure is identical, they will be automatically concatenated and you end up with one table.

           

          3. Since both tables, 1 and 2 are identical in structure, they will be automatically concatenated.