finding only tada not found in other table

Mon, 15 Nov 2010 06:42:28 GMT

Hi,

I have 2 qvds. Both contain same field.

In qvd1, There is data that is only according to created date .

But In Qvd2 , There is data according to change date.

there is a key that is commom in both table.

I want to fetch only data from qvd1 that do not exist in qvd2 according to the key.

All data in qvd1 are not changed , So qvd2 contain only little data.

Anonymous — Mon, 15 Nov 2010 07:10:50 GMT

Hi,

Keep (Look at syntax in F1-help) should help you with that.

Example:

QVTab1:

select * from Table1;

QVTab2:

left keep select * from Table2;

This will load all rows from Table1 and the intersecting part from Table2.

topic finding only tada not found in other table in QlikView