Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
andreyfcdk91
New Contributor III

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
MVP
MVP

Re: Concat two tables with same structure

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.

andreyfcdk91
New Contributor III

Re: Concat two tables with same structure

Thanks..

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

That's why i need concat two tables manually

krishna_2644
Valued Contributor III

Re: Concat two tables with same structure

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

Thanks

Krishna

crusader_
Valued Contributor

Re: Concat two tables with same structure

Hi,

You can make explicit concatenating like below:

Table1:

LOAD

     ....

from...;

....

<Your free code>

.....

Concatenate(Table1)

LOAD

     ....

from ...;

Hope this helps.

Regards,

Andrei

Community Browser