9 Replies Latest reply on Oct 6, 2016 7:07 AM by Mac Chadwick Ranier Tolentino

    Removing duplicate records from data source inside Tableau

    Aya Elzarka

      I have a database that for some reason contains duplicate records. I want to remove these duplicate records inside Tableau before I start my analysis. How do I write a formula to use it  as a condition in the data source filter?

       

      A duplicate record is identified by one ID field where an ID is duplicated twice or more, but the table has another field containing id unique numbers identifying the records of it.

       

      Thank you