concatenate the intersected data

Tue, 16 Nov 2010 07:55:08 GMT

Hi,

I want to concatenate 2 qvds with intersected data.

I have 2 qvds. Both contain same field.

I want to load qvd2 with all data but load only intersected data from qvd1 . then i want to concatenate both qvds.

urget reply needed.

deepakk — Tue, 16 Nov 2010 08:03:34 GMT

HI rajni,

Use the Exists function or use inner join to make interaction between two qvds

eg:

Load * from A.

concatenate

Load

* from B where exists(PrimaryKey,PrimaryKey)

-----------------------------------------------------------------------

Load

* from A;

inner join

Load

* from B;

topic concatenate the intersected data in QlikView