How to attach one table to another one (vertical)?

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

Hello everybody,

i am new to qlikview. So this question might be easy or maybe already answered.

Situation: I've got two big tables on a sql server. Both tables got the same structure (same columns). One table got the data from 2017 and one 2018. Because of the size of the table, i have to dowload the data as an .qvd file via OLE DB connection. After that, i load both qvd in one .qvw file.

Is there a way to add one table to the other as "extra-rows" at the bottom ? My goal is too have one table with the data from 2017 and 2018.

1. Downloading as qvd:

OLEDB CONNECT TO [serverinfo];
tbl_2017:
LOAD "ID",
"NAME",
"ADRESS",
SQL SELECT *
FROM table2017;
STORE tbl_2017 into tbl_2017.qvd (QVD)

2. Loading qvd in qvw:

LOAD "ID",
"NAME",
"ADRESS",
FROM
[C:\Users\Marko\tbl_2017.qvd]
(qvd);

****same code for the data from 2018****

Thanks in advance.

Best Regards Marko

Re: How to attach one table to another one (vertical)?

ignacio_pena — Fri, 10 May 2019 12:11:19 GMT

Hello Marko,

To join all the data in a table you should use a concatenate. I give you an example:

In the same qlik:

TABLE:

LOAD "ID",
"NAME",
"ADRESS",
FROM
[C:\Users\Marko\tbl_2017.qvd]
(qvd);

Concatenate

LOAD "ID",
"NAME",
"ADRESS",
FROM
[C:\Users\Marko\tbl_2018.qvd]
(qvd);

And then you can export everything in a single qvd.

store * from TABLE into TABLE_OK.qvd;

Regards,

topic How to attach one table to another one (vertical)? in QlikView

How to attach one table to another one (vertical)?

Re: How to attach one table to another one (vertical)?