Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
following table:
ID, Count
100, 1
200, 5
300, 4
100, 5
100, 4
200, 1
If ID = 100 and Count = 1 he should not load this data but everything else.
I thought that where ID <> 100 and Count = 1 should work but in this case he delete everything which have ID 100 and count1. But I need this where clause in a combination [ID = 100 AND Count = 1]!!!
Thanks
right then either of these should work:
Where not (Object = 'A' and Anzahl > 2);
or
Where Object <> 'A' or Anzahl <= 2;
WHERE NOT EXISTS (id,1)
Try this:
Where not (ID = 100 and Count = 1);
This should also work:
Where ID <> 100 or Count <> 1;
Try like this?
Load
*
from YourTable where ID <> 100 or Count <> 1;
I need a combination look at my example if Object = A and Anzahl > 2 this should not be loaded...
IF Object = A and Anzahl = 1 It must be loaded!
!
right then either of these should work:
Where not (Object = 'A' and Anzahl > 2);
or
Where Object <> 'A' or Anzahl <= 2;
Where not Exists (Object = 'A' and Anzahl > 2);
What is your desired output for the attached qvw?