Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Fixed it by using the below condition
Where (Not Match(Code,'123') OR Not Match(Value,'456V01'));
Fixed it by using the below condition
Where (Not Match(Code,'123') OR Not Match(Value,'456V01'));