Delete rows

[stabben23]

Hi,

I want to delete the the row with combination 0 and 4 (red) in my script. How will my where statment look like, I use qvd file.

[#2]

Load * from Table where Orderrad=20 and subradlinje=0

[Anonymous · Accepted solution]

I guess:

LOAD

...

FROM...

WHERE NOT(Subradlinje=0 AND Type=4);

[#4]

the where clause should be

Where Subradlinje <> 0 and Type<> 4;

[stabben23]

Michael, that was my first solution before I post in the community, but:

[stabben23]

Sorry Michael,

you are right, forgot the bracket , thanks

[Anonymous]

HI,

Are your fields Subradlinje and Type expressions or dimensions?

Because if they are expressions, then you have to identify the case where Subradlinje=0 AND Type=4 and make a where condition to exclude those case

Otherwise if they are dimensions, then use the condition:

WHERE NOT (Subradlinje=0 AND Type=4);