Last Modified Date: 30 Aug 2018
- Tableau Desktop 2018.2.0
- Windows 10
ResolutionThere are multiple ways to deal with duplicated data. Below are three ways that show how duplicated data can be handled at each stage:
Option 1: At the data source levelOpen Superstore data in Excel and remove the duplicated data in the Returns table.
Option 2: In Tableau PrepUse the Aggregate function in Tableau Prep to remove the duplicates in the Returns table. For more information, see Aggregate and group values.
Option 3: In Tableau DesktopUse LODs in Tableau Desktop to remove duplicates in the results. For more information, see Removing Duplicate Data with LOD Calculations.
CauseThe duplicated data in the Returns table is to coincide with the release of Tableau Prep and to allow the use of the sample data to demonstrate data preparation.
Additional InformationThe Returns table in Superstore data from 10.5 and earlier is not duplicated.
There are more scenarios and ways that Tableau Prep can be used to handle duplicated data, which can be seen in the article, Removing Duplicate Data in Tableau Prep.
Thank you for providing your feedback on the effectiveness of the article.
Open new Case
Training and Tutorials