Load if not equal

[qlikviewalex]

Hello,

I have a problem with my Skripting.

I join two Tables to one.

But I want only the elements, where the [Object-ID] is not included in Table1

Aufgaben:

LOAD [Object-ID],

     a,

b

FROM

[..\10_Data\test.xlsx]

(ooxml, embedded labels, table is Aufgaben);

join load distinct

[Object-ID],

   a,

b

FROM

[..\30_QVDs\Aufgaben.qvd] where ...............

(qvd);

I hope someone can help me.

Alex

[qlikviewalex]

Thanks. It works.

The mistake was the (qvd);

That's wrong:

[..\30_QVDs\Aufgaben.qvd]

where not exists([Object-ID]

(qvd);

That's work:

[..\30_QVDs\Aufgaben.qvd](qvd) where not exists( [Object-ID]);