How to ignore particular row based on two columns in Qlikview Load script

[vikasshana]

Hi,

I've below data in my QVD.

Code	Value	Sales
123	123V01	100
123	123V01	200
123	456V01	300
456	456V01	400
456300	456V01	500
456	456V01	600

I would like to ignore below row in the load script as it is a wrong entry

Code

Value

Sales

123

456V01

300

I tried below match condition but it is throwing syntax error message.

Where Not Match(Code,'123') AND Not Match(Value,'456V01')

Need your suggestion on how to get it.

[vikasshana · Accepted solution]

Fixed it by using the below condition

Where (Not Match(Code,'123') OR Not Match(Value,'456V01'));