Create DQ rule to validate data in same column

Hi ​@Vaishali , dq rules in Ataccama ONE usually work on the row basis - rule condition would usually evaluate the column values in specific row of data. You can build aggregated rules that would compare specific row of data with aggregated data in the dataset but you need to have a clear idea how you would aggregate it based on what exactly you’re trying to see in the result.

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.