Skip to main content

Hi,

I want to create DQ rule to check data within same column. For example, from below table, I want to check if Value of Category B is >= Value of Category D.

How can I do this in the Ataccama One UI?

 

Thanks

Category Value
A 5
B 2
C 6
D 4

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


Reply