topic Concat two tables with same structure in QlikView

Concat two tables with same structure

Anonymous — Thu, 21 May 2015 18:13:54 GMT

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.

Re: Concat two tables with same structure

petter — Thu, 21 May 2015 18:27:35 GMT

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.

Re: Concat two tables with same structure

Anonymous — Thu, 21 May 2015 18:49:17 GMT

Thanks..

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

That's why i need concat two tables manually

Re: Concat two tables with same structure

Qrishna — Thu, 21 May 2015 18:51:06 GMT

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

Thanks

Krishna

Re: Concat two tables with same structure

crusader_ — Thu, 21 May 2015 19:32:09 GMT

Hi,

You can make explicit concatenating like below:

Table1:

LOAD

....

from...;

....

.....

Concatenate(Table1)

LOAD

....

from ...;

Hope this helps.

Regards,

Andrei