Remove exact duplicate records from your dataset
When you have records in your dataset where the values in all columns are identical, you can use the Remove duplicate rows transform to retain only one example of each identical record.
You can find this transform by clicking on the Search transformations icon at the top of the Transformer Grid:
Search for the phrase "duplicate" to surface the Remove duplicate rows transform:
Click on the transformation in the list of search results. This will open the transform builder. There are no additional options for configuring this transformation, so you can click Add to add the step to your recipe:
More Information
For product help and specific questions, check out the Trifacta Community
Additional information about removing duplicates from your dataset can be found in our product documentation