Skip to main content
Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
Marko
Contributor
Contributor

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

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

 

 

1 Solution

Accepted Solutions
ignacio_pena
Contributor III
Contributor III

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,

 

 

View solution in original post

1 Reply
ignacio_pena
Contributor III
Contributor III

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,