When I run the profiler, the 'simple' stats include two different counts: one for "unique" values and the other for "Distinct" values.
I don't understand the difference between them.
Can someone please explain how I should interpret the case when:
Row Count = 658,645 (OK, I think I understand this one )
Null Count = 0 (I understand this one too )
Distinct Count = 5,097
Unique Count = 541
Duplicate Count = 4,556
The first 100 community members completing the Open Studio survey win a $10 gift voucher.
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Watch the recorded webinar!
Learn how to enable Data Governance
Take a peek at the definitive guide to Government Data Quality