Connect this node to a table node to remove duplicate rows from that table. The Distinct node is used to find and delete duplicate rows from the given table. The Distinct node defines duplicate rows as rows containing identical values in every column. To define duplicate rows by comparing only specified columns, use the Remove Duplicates node.
How to Configure a Distinct Node
- Connect the Distinct node to the relevant table node.
- From the node's Properties panel, go to the Distinct Node window and click Preview to see a preview of the table with duplicate rows removed.