Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.
Thanks..
But before concating this two tables i make several intermediate operations.
That's why i need concat two tables manually
QlikView automatically concatenates two tables with same field names no matter what operations are made.
Thanks
Krishna
Hi,
You can make explicit concatenating like below:
Table1:
LOAD
....
from...;
....
<Your free code>
.....
Concatenate(Table1)
LOAD
....
from ...;
Hope this helps.
Regards,
Andrei