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.
(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.
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.
(Since the duplicated entries have same data, they will be merged together – returning only one entry)
Next add an output step.
Executing this we’ve.
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.
