I have a requirement to develop a rule that checks value of an attribute should be from a given list of values. The attribute should have at least one record of each of the list item. It should fail if any of the values don’t appear in the attribute. I cannot consider lookup as lookup will perform OR operation on the given list, instead I would like to have AND operation.
e.g., list of values List1 = {1,2,3,4,’pqr’, ‘abc’}, column name = Col1
Test case - Col1 should have at least one entry of each item from List1. It should fail if any of the 6 values from List1 fail to appear in Col1 values
Thanks for the help in advance!