Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear Community
I have a challenge with multiple exclusions of data over multiple dimension in my loading script
Below is an example
where (Customer_Code <> 100010) or
(Product_code <> 762512,
762528)
762595,
762627);
I am still getting errors. Sure my syntax is not correct. Please can you advise
Regards
It should. Are you sure that both conditions should be connected with OR or might it rather be AND?
- Marcus
Maybe this:
where Customer_Code <> 100010 or match(Product_code, 762512, 762528, 762595, 762627) = 0;
- Marcus
Thanks, doesn't seem to exclude the values from the model
Regards
It should. Are you sure that both conditions should be connected with OR or might it rather be AND?
- Marcus
Hi
Tested it and yes it works on 'and'
I adopted your suggestion and make small change :
where match (Customer_Code, 100010)=0
and match(Product_code, 762512,762595)=0;