Distinct Node - Data360_DQ+ - Latest

Data360 DQ+ Help

Product type
Software
Portfolio
Verify
Product family
Data360
Product
Data360 DQ+
Version
Latest
Language
English
Product name
Data360 DQ+
Title
Data360 DQ+ Help
Copyright
2024
First publish date
2016
ft:lastEdition
2024-07-09
ft:lastPublication
2024-07-09T15:09:58.774265

The Distinct node is used to remove duplicate records from a specified field.

For example, using the Distinct node on the Name field in the following sheet:

 

Name

Bob

Bob

Alice

Would return a sheet containing only one distinct record for "Bob."

Name

Bob

Alice

The Distinct node is similar to the Group By node in that it groups duplicate records in a specified field. Unlike Group By, however, Distinct does not allow for subsequent aggregation.