not exists 2 Qvd tabel

[#1]

Hi,

i want to extract records from 2 QVD tabel where the records from 1. qvd not in 2.qvd.

Table1:

BP_ID

Tabel2:

BP_ID

all BP_ID from Tabel1, where not in Tabel2.

Thanks

Regards

[#2]

table2:

load

     BP_ID

from...

table1:

load

     BP_ID

from ....

where not exists(BP_ID)

[#3]

Hi,

Thanks

but i get the all.

Tabelle2:
Load
BP_ID
FROM $(VarQvdPfad)Transaktionsdaten\Fakten_Billing_Line.qvd (qvd);

Tabelle1:
noconcatenate Load
BP_ID
FROM $(VarQvdPfad)CSP\CSP_BP.qvd (qvd)

where not exists (BP_ID);

[#4]

Good to hear you solved your problem by yourself.

[#5]

hi

yes it show all record because of both of table link with ID field

You do this manner:

T1:
LOAD ID
FROM

(biff, embedded labels, table is Sheet3$);
T2:

LOAD ID as ID2
FROM

(biff, embedded labels, table is Sheet4$) where not Exists(ID);

Regards

Sonu Srivastava

[#6]

Hi Thanks,

the Problem isn't solved. Sorry for my bad Englisch.

I still get the all Records. I changed them to flowing, but i get the all record.

T1:
LOAD ID
FROM

(biff, embedded labels, table is Sheet3$);
T2:

LOAD ID as ID2
FROM

(biff, embedded labels, table is Sheet4$) where not Exists(ID);

do you have any Idea?

Thanks

[#7]

T1:
LOAD ID
FROM

(biff, embedded labels, table is Sheet3$);
T2:

LOAD ID as ID2
FROM

(biff, embedded labels, table is Sheet4$) where not Exists(ID);

drop table T1;

[rbecher · Accepted solution]

If you ar using different field names you have to use:

Where not Exists(ID, ID2)

- Ralf

[#9]

Hi Ralf,

Thankyou, but i get the all record. the 2 tables are QVD Tabel und not Excel.

is that problem ?

Shideh

[rbecher]

Please upload an example..