Hi,
I want to create DQ rule to check data within same column. For example, from below table, I want to check if Value of Category B is >= Value of Category D.
How can I do this in the Ataccama One UI?
Thanks
Category | Value |
A | 5 |
B | 2 |
C | 6 |
D | 4 |
Hi,
I want to create DQ rule to check data within same column. For example, from below table, I want to check if Value of Category B is >= Value of Category D.
How can I do this in the Ataccama One UI?
Thanks
Category | Value |
A | 5 |
B | 2 |
C | 6 |
D | 4 |
Hi
Could you please clarify what is the final goal of the rule?
Do you need to compare the values only between specific categories or between all of them (basically identifying the maximum)?
Thank you!
Ivan
Thanks @ivan.kozlov for your response.
I am not looking for aggregate values. I want to compare some of the categories with each other. The comparison may be checking values less than or greater than each other. Or it can be checking if value of category B is x times value of category A.
Unfortunately i don’t think what you’re trying to do is possible especially using only rules created in webapp UI. For rule condition to be evaluated, all the input attributes should be withing the same row of data and the data you need for your rule will never be in one place unless the catalog item structure would look completely different (values for A, B, C, D that have to be compared would be in the same row).
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.