Multiple Values exclusion from multiple dimensions in loading script

[george456]

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

[marcus_sommer]

Maybe this:

where Customer_Code <> 100010 or match(Product_code, 762512, 762528, 762595, 762627) = 0;

- Marcus

[george456]

Thanks, doesn't seem to exclude the values from the model

Regards

[marcus_sommer · Accepted solution]

It should. Are you sure that both conditions should be connected with OR or might it rather be AND?

- Marcus

[george456]

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;