Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Load * from Table where Orderrad=20 and subradlinje=0
I guess:
LOAD
...
FROM...
WHERE NOT(Subradlinje=0 AND Type=4);
the where clause should be
Where Subradlinje <> 0 and Type<> 4;
Michael, that was my first solution before I post in the community, but:
Sorry Michael,
you are right, forgot the bracket , thanks
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);