Unique value check within the Data Quality Inidcator


(Nicholas Zeolla) #1

Hi,

I am looking to create a rule within the “Data Quality Indicator” to test for uniqueness within a column.

I have built a plan similar to the example file 7.01, but can’t find anything that works when creating a rule to check for uniqueness within a column. Any advice?


(Victoria Tuktarova) #2

Hello Nicholas,

I am afraid there is no such rules to check uniqueness in DQ Indicator. Therefore, I would suggest using countUnique expression in Group aggregator step. As a result it will show which values are unique and which are not with 1 and 0.

Also, you can use Representative creator step to find and remove duplicates.

Kind regards,
Victoria