Get Ready For Your Tableau Certification
  • Bernard

Using Tableau Prep to Remove Duplicate Entries


Using Tableau prep to remove duplicates

Duplicated entries is one of the common challenges that you can encounter when preparing data. And in this article, am going to share with you how you can deal with duplicated entries in Tableau Prep.

In this case, I will be using this sample data.

sample data with duplicated entries

(And as you can see in the above snapshot, the highlighted entries have been duplicated – and therefore this article will guide you on how to remove the duplicates).

Once you’ve connected your data to Tableau Prep, add an aggregate step.

adding an aggregate step in Tableau prep

Under settings, select all the fields in the data set except the Number of Rows field and drag them to the Grouped Fields section on the right.

selecting all fields from the data set

(Since the duplicated entries have same data, they will be merged together – returning only one entry)

Next add an output step.

adding an output step in Tableau prep

Executing this we’ve.

final cleaned data without duplicates

From the output table (cleaned data), you can see that it has 9 entries instead of the initial 12 entries at the beginning – meaning that, the three duplicates in this data have been removed.

I hope this article was helpful to you. To receive more of the Tableau tips kindly join our mailing list by subscribing below.

Thank you for reading.

LEAD MAGNET - 2.png
FREE INTRO COURSE -2.png