Concatenate resident tables

[#1]

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;

[giakoum]

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

[ashfaq_haseeb · Accepted solution]

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

[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]

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]

agree

[#8]

Thanks Ashfaq for help..

[ashfaq_haseeb]

Welcome

Regards

ASHFAQ