Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
dwertmann
Contributor
Contributor

Load where Klausel

Hallo,

möchte alles laden bis auf:

Rechnungsnummer xyz von der Firma 123

Rechnungsnummer asd von der Firma 345

Load * from ...qvd where ???????;

Gruß Benno

4 Replies
puttemans
Specialist
Specialist

Load *

FROM .....qvd

Where Firma <> 123 or Firma <> 345;

luciancotea
Specialist
Specialist

Where Firma <> 123 or Firma <> 345;

...that will always be true....you mean:

Where not (Firma = 123 or Firma = 345);

Gysbert_Wassenaar

LOAD *

FROM xxx.qvd

WHERE not match(Firma, '123','345');


talk is cheap, supply exceeds demand
dwertmann
Contributor
Contributor
Author

Habe folgendes versucht, aber dann ist die ganze Firma 123 und 456 weg, es sollen nur 4 Rechnungen wegfallen.

Load *

where not (Firma = '123' and RechnungsNr <> '50028009') and not ( Firma = '123' and RechnungsNr <> '50027882')
  and not ( Firma = '456' and RechnungsNr <> '50021759') and not (Firma = '456' and RechnungsNr <> '50034161');