Equivalent of a DELETE WHERE with several criteria ?

[Julien94]

Hi, I load a all_data qvd but I need to exclude rows with several criteria

here's a simplified example : I want everything except the lines where Data type = a and Society = 1 and Date < 01.01.2020. In this example it corresponds to the first 2 lines

How to make the equivalent of a DELETE WHERE with several criteria ?

Data type	Society	Date
a	1	01.05.2020
a	1	01.06.2020
a	1	01.07.2020
a	2	01.05.2020
a	2	01.06.2020
a	2	01.07.2020
b	1	01.05.2020
b	1	01.06.2020
b	1	01.07.2020
b	2	01.05.2020
b	2	01.06.2020
b	2	01.07.2020

[Kushal_Chawda · Accepted solution]

try below

Data:

load *

where  Filter_Flag=0;

load [Data Type],

          Society,

          Date,

         if( [Data Type]='a' and Society='1' and Date < makedate(2020,01,01),1,0) as Filter_Flag

FROM table;

drop field Filter_Flag;