2 Replies Latest reply on May 9, 2017 6:26 PM by Morgan DUARTE

    Join tables but remove duplicates first

    Morgan DUARTE

      Hi there,

       

      In one data source, I am adding a left join to a mapping table to bring additional dimensions to the data source. However this mapping table is handled on Excel and I found time to time some duplicates, which then duplicate the value in Tableau as well.

       

      Anyway for Tableau to clean this first? To take the first record for example, to ensure a 1:1 relationship.

       

      Thank you