Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On Demand Webinar: See Why Thousands of QlikView Users Have Switched to Qlik Sense. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Concatenate resident tables

I want to concatenate 2 resident tables Test1 & Test2 with resulting table named Final below is sample code which i have been implemented which is not working properly please help??

Test1:

Load

A,

B,

C,

D

from Table1;

Test2:

Load

A,

P,

Q

from Table2;

Final:

Load

A,

B,

C,

D

resident Test1;

concatenate(Final)

Load

A,

P,

Q

resident Test2;

1 Solution

Accepted Solutions
ashfaq_haseeb

Try like below

Test:

LOAD A,

     B,

     C,

     D

FROM

[Book1 (5).xlsx]

(ooxml, embedded labels, table is Sheet1);

//Concatenate(Test)

Test2:

LOAD A,

     V,

     H

FROM

Book111.xlsx

(ooxml, embedded labels, table is Sheet1);

NoConcatenate

Main:

Load *

Resident Test;

DROP Table Test;

Concatenate(Main)

Load *

Resident Test2;

DROP Table Test2;

Regards

ASHFAQ

View solution in original post

8 Replies
giakoum
Partner
Partner

your qvw works just fine. what is making you believe it is not?

ashfaq_haseeb

Try like below

Test:

LOAD A,

     B,

     C,

     D

FROM

[Book1 (5).xlsx]

(ooxml, embedded labels, table is Sheet1);

//Concatenate(Test)

Test2:

LOAD A,

     V,

     H

FROM

Book111.xlsx

(ooxml, embedded labels, table is Sheet1);

NoConcatenate

Main:

Load *

Resident Test;

DROP Table Test;

Concatenate(Main)

Load *

Resident Test2;

DROP Table Test2;

Regards

ASHFAQ

View solution in original post

colin_albert

The table Final will not get created, as it shares exactly the same columns as Test1, instead you will get a table Test1 with twice the number of rows.

This should work

Final:

Load

A,

B,

C,

D

from Table1;

concatenate (Final)

Load

A,

P,

Q

from Table2;


giakoum
Partner
Partner

and this is exactly what Rahul has done in the attached qvw.

So what is not working?

ashfaq_haseeb

Its about Resident load concept.

He has to use NoConcatenate keyword in between

Regards

ASHFAQ

giakoum
Partner
Partner

agree

Not applicable

Thanks Ashfaq for help..

ashfaq_haseeb

Welcome

Regards

ASHFAQ