Help and Support > Table of Contents > Make Unique

Make Unique


The Make Data Unique block removes any duplicate rows from the incoming data. It looks at all of the rows, and if any two or more rows contain exactly the same values in all columns it passes only one copy of that row. It can also be used to Count duplicates in data and can include the number of rows found as part of the output set of Unique rows.

Make Unique Image

Block Connection Stubs

  • 1 The input data set.
  • 2 The output data set of unique rows.