I am making a DQ evaluation rule in ataccama one ui where I have to subtract each long value of catalogue item from its corresponding long value in lookup and if the difference is greater than 100, I want to raise that particular value as invalid sample, so far I am not able to achieve this, it would be great if anyone can help me with this.
In the Lookup step configuration, use the lookup.key expression to store the value into some working column:

From there you could calculate the difference between the src_value and the working column, and decide the VALID/INVALID result based on the outcome.
Does that help?
Thanks for the solution
Reply
Login to the Ataccama Community
No account yet? Create an account
For Ataccama Customers and Partners
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.