Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Concat two tables with same structure

Good day!

I have one (Main_table) table, which i load from excel file:

Main_table:

Name   Brand

Name1 Brand1

Name2 Brand2

Name3 Brand3

I want to add to this table Second_table from qvd file, which have following fields:

Second_table:

Name   Brand

Name4 Brand4

Name5 Brand5

Name6 Brand6

In result it must be:

Name   Brand

Name1 Brand1

Name2 Brand2

Name3 Brand3

Name4 Brand4

Name5 Brand5

Name6 Brand6

Please, help.

Best regards.

4 Replies
petter
Partner - Champion III
Partner - Champion III

QlikView's auto concatenation will do the work for you:

LOAD

     *

FROM abc.xls (...);

LOAD

     *

FROM def.qvd (qvd);

And they will end up in the same table as long as all the fieldnames are the same.

Anonymous
Not applicable
Author

Thanks..

But before concating this two tables i make several intermediate operations.

That's why i need concat two tables manually

krishna_2644
Specialist III
Specialist III

QlikView automatically concatenates two tables with same field names no matter what operations are made.

Thanks

Krishna

crusader_
Partner - Specialist
Partner - Specialist

Hi,

You can make explicit concatenating like below:

Table1:

LOAD

     ....

from...;

....

<Your free code>

.....

Concatenate(Table1)

LOAD

     ....

from ...;

Hope this helps.

Regards,

Andrei