How to remove duplicates in tableau prep

by Joel Akaje-Macauley

Firstly to define duplicates: These are values in which the entire row's values are identical to another entire row of data.

  1. Add in an aggregate step
  2. Add every field to grouped fields (select top field and hold shift then select last field)
  3. Add in number of rows field to aggregated fields
  4. Add in a clean step to see the results, click on the number of rows field to see which values were initially duplicates.