Skip to main content

Hello all,

I want to create a DQ rule, In this rule I need to check a numeric field if the value is in the predefined interval or not. Let me give an example of logic. 

I have a column X contains ‘types of product’ and column Y contains ‘value of product’. And have a list of valid values. If the value of X is ‘abc’ then Y must be in the interval 1-30. If hte value of X is ‘xyz’ then Y must be in 1-200 and so on.

I was going to create a lookup file for this one, but couldn’t be sure how to define intervals. Does someone know how to implement my DQ rule for this logic ? 

Thanks a lot !

​@sumeyra Hello! you should be able to use the standard rule template to create this rule. By having two inputs, one for the name of the product, and another for the interval, you can specify what the interval has to be for that specific product. all youll need to do is add conditions for the product and its predefined interval.

Rule Logic: (Product is "Product Name") AND (NProduct Value] < 1) or (oProduct Value] > 30)

Hello ​@ThomasPro , thanks for reminding this one! I don’t know why i have tried the harder solution.😪 Simple and the best! 👌 Thanks a lot. 

Of course!! Glad I could help! ​@sumeyra 

Reply


Community Terms of Use & ConditionsCookie settings