How to identify if a list of given values is present in an attribute

Hi ​@mp_ataccamauser ,
I’m not sure if i understand your requirements correctly but it looks like the rule you describe is supposed to evaluate the dataset as a whole and not individual rows of data, as that’s the only way to to verify that the value from a list appear in specific attribute/column in the dataset at least once.

The rules you create in Ataccama web-app perform DQ evaluation on per-row basis. If you need to do something like uniqueness check - you can use aggregation as well to group items base on some criteria, but i can’t think of a way to implement the rule you need using standard rule capabilities.

Hi ​@ivan.kozlov yes, we would need to perform the check on whole dataset needing aggregations. Do u suggest any implementations using One Desktop if web implementations could possibly be limited in this case?

Thanks in advance!

​@mp_ataccamauser in general for aggregation checks we recommend using Aggregation rules in web application, however i can’t think of a way to implement the logic you need using this type of rules.
I believe ONE Desktop might be a better tool for the job here as you’d probably need to build a logic to what will take all the values in specific column, put them together and then generate a list of unique column values that can be compared against reference data.