topic Re: Concatenation two tables from one data source in QlikView

Concatenation two tables from one data source

cliff_clayman — Wed, 25 Nov 2020 16:16:04 GMT

I have one table that I am trying to concatenate to itself basically with just one additional manually defined field. Here is the table structure:

Table1:

LOAD MonthNum,

Account,

Cost,

'2016' AS Year

FROM

(ooxml, embedded labels, table is Sheet1);

I then want to add data from another file (Table2.xlsx) that has the same fields except for the Year. What is the best way to do this? I would like to use a QVD if possible.

Re: Concatenation two tables from one data source

bgerchikov — Thu, 08 Dec 2016 16:55:17 GMT

Hi Cliff,

You can use either Join command or Concatenate:

Table1:

LOAD MonthNum,

Account,

Cost,

'2016' AS Year

FROM

(ooxml, embedded labels, table is Sheet1);

Store Table1 into Table1.qvd();

Join(Table1)

Load *

FROM
[Table1.qvd]
(qvd)

Join(Table1)

LOAD MonthNum,

Account,

Cost

FROM

(ooxml, embedded labels, table is Sheet1);

Re: Concatenation two tables from one data source

maxgro — Thu, 08 Dec 2016 16:57:42 GMT

You can add the Table2 rows to Table1 using a concatenate

concatenate (Table1)

LOAD MonthNum,

Account,

Cost

FROM

(ooxml, embedded labels, table is Sheet1);