topic Append tables into New Table in QlikView

Append tables into New Table

Fri, 18 Nov 2016 16:44:42 GMT

I have two tables, Table1 and Table2. I want to create a new table called Table3 and simply append the records of Table1 and Table2 into Table3. What script will accomplish this ?

Re: Append tables into New Table

Fri, 18 Nov 2016 16:58:49 GMT

I used the following example from another Qlikview discussion thread and it worked like a charm.

MyTable]:

LOAD my fields from the first Excel file;

CONCATENATE ([MyTable])

LOAD my fields from the second Excel file;

etc.

Re: Append tables into New Table

Peter_Cammaert — Fri, 18 Nov 2016 17:01:36 GMT

Then, in order to close the discussion, please mark your own answer as Correct.