hi,
I have a scenario where two columns ID and Value to be verified using DQ check together (like key value pair)
against two columns of Table1 key (compared against ID) and name (compared against Value)
I am using Atacama web, I see we can create lookup but it could be created only for one column and not both.
Appreciate your suggestions here.
Cheers!
Best answer by ivan.kozlov
Hi
Unfortunately at the moment it is only possible to use List Of Value type of lookups which have just a single column and attributes in the DQ Rule can be compared against this LoV. Using lookups to pull some values from it is unfortunately not possible in case you’re building condition builder or expression rules in web application. However with Component rules you can use any lookups.
I’ve submitted the same requirement as FR to our product and engineering teams some time ago so this is something that might be added for webapp rules in future, however at the moment don’t know when exactly this might happen.
I hope this helps.
Ivan
+3Hi
Unfortunately at the moment it is only possible to use List Of Value type of lookups which have just a single column and attributes in the DQ Rule can be compared against this LoV. Using lookups to pull some values from it is unfortunately not possible in case you’re building condition builder or expression rules in web application. However with Component rules you can use any lookups.
I’ve submitted the same requirement as FR to our product and engineering teams some time ago so this is something that might be added for webapp rules in future, however at the moment don’t know when exactly this might happen.
I hope this helps.
Ivan
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
