How to remove duplicates in tableau prep

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.
Author:
Joel Akaje-Macauley
Powered by The Information Lab
1st Floor, 25 Watling Street, London, EC4M 9BR
Subscribe
to our Newsletter
Get the lastest news about The Data School and application tips
Subscribe now
© 2024 The Information Lab