Writing DQ rule for interval values

Question

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 !

ThomasPro · Accepted Answer

​@sumeyraHello! 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 ([Product Value] < 1) or ([Product Value] > 30)

sumeyra · Answer

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.

Sign up

Login to the Ataccama Community

Scanning file for viruses.

This file cannot be downloaded