topic Concatenate two Tables in QlikView

Concatenate two Tables

Tue, 18 Aug 2009 15:12:21 GMT

Good Morning,

i have 2 "description" tables in 2 different databases. I have to create only a tables with the value of the 2 previous tables.

How i can do this??

Thank you soo much.....

Concatenate two Tables

Tue, 18 Aug 2009 15:17:12 GMT

you want all the records from both the tables then use UNION

If you want matching records then use Equi JOIN.

-Raghu

Concatenate two Tables

Wed, 19 Aug 2009 17:08:25 GMT

Thank you for answer...

I have tried to use UNION comand but it doesn't work.

My databases are in access97.

Concatenate two Tables

Wed, 19 Aug 2009 17:13:17 GMT

try "concate " e.g

table1:

load ................................ from

concate

table 2:

load ..................................... from

Concatenate two Tables

Wed, 19 Aug 2009 17:13:41 GMT

I posted this a while back. Basically I concatenate both tables to a temp table. Reload this temp table into a table an delete the temp table. It solves a lot of issues when concatenating data...

Edited ... wrong example, correct one below

SalesDocItem_temp:
LOAD
[Subtotal 6_KZWI6] as OrderAmount,
MaterialNumber_Key,
SalesDocument_Key
FROM (qvd)
Where MaterialNumber_Key ='000000037000002000';

concatenate
LOAD
[Sales doc.type_AUART] as OrderType,
[Document date_AUDAT] as DocumentDate,
SalesDocument_Key
FROM (qvd);

SalesDocItem:
NOCONCATENATE LOAD
SalesDocument_Key,
OrderAmount,
MaterialNumber_Key,
OrderType,
DocumentDate

RESIDENT SalesDocItem_temp;

DROP table SalesDocItem_temp;

Concatenate two Tables

Wed, 19 Aug 2009 17:20:07 GMT

If two tables that are to be concatenated have different sets of fields, concatenation of two tables can still be forced with the concatenate prefix. This statement forces concatenation with an existing named table or the latest previously created logical table.

tab2:

load * from file2.csv;

.. .. ..

Concatenate (tab1) load * from file3.csv;