topic not exists 2 Qvd tabel in QlikView

not exists 2 Qvd tabel

Thu, 12 May 2011 11:31:55 GMT

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

not exists 2 Qvd tabel

Thu, 12 May 2011 11:36:41 GMT

table2:

load

BP_ID

from...

table1:

load

BP_ID

from ....

where not exists(BP_ID)

not exists 2 Qvd tabel

Thu, 12 May 2011 12:01:55 GMT

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);

not exists 2 Qvd tabel

Thu, 12 May 2011 12:31:09 GMT

Good to hear you solved your problem by yourself.

not exists 2 Qvd tabel

Thu, 12 May 2011 12:38:17 GMT

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

not exists 2 Qvd tabel

Thu, 12 May 2011 12:57:01 GMT

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

not exists 2 Qvd tabel

Thu, 12 May 2011 13:05:09 GMT

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;

not exists 2 Qvd tabel

rbecher — Thu, 12 May 2011 13:07:50 GMT

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

Where not Exists(ID, ID2)

- Ralf

not exists 2 Qvd tabel

Thu, 12 May 2011 13:31:26 GMT

Hi Ralf,

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

is that problem ?

Shideh

Re: not exists 2 Qvd tabel

rbecher — Thu, 12 May 2011 13:36:28 GMT

Please upload an example..

not exists 2 Qvd tabel

Thu, 12 May 2011 14:01:21 GMT

Hi Rolf,

Thanks, That works fine. I had checked again and it's work.

Thank all answered.