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.