Concat two tables with same structure

[Anonymous]

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.

[petter]

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]

Thanks..

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

That's why i need concat two tables manually

[Qrishna]

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

Thanks

Krishna

[crusader_]

Hi,

You can make explicit concatenating like below:

Table1:

LOAD

     ....

from...;

....

<Your free code>

.....

Concatenate(Table1)

LOAD

     ....

from ...;

Hope this helps.

Regards,

Andrei