topic Re: Multiple Values exclusion from multiple dimensions in loading script in App Development

Multiple Values exclusion from multiple dimensions in loading script

george456 — Sat, 16 Nov 2024 17:28:26 GMT

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 — Thu, 18 Feb 2021 12:14:25 GMT

Maybe this:

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

- Marcus

george456 — Thu, 18 Feb 2021 13:22:46 GMT

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

Regards

marcus_sommer — Thu, 18 Feb 2021 13:37:46 GMT

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

- Marcus

george456 — Thu, 18 Feb 2021 13:57:57 GMT

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;