3 Replies Latest reply on Nov 14, 2017 7:16 AM by Brent Mathison

    Distinct / Unique data connection / load to tableau.

    murat topuz

      Hi,

       

      I would like to know what options I do have to eliminate or not load duplicate data into tableau, while connecting to CSV or XLS.

       

      I do want to eliminate duplicates during load / connection phase, as I do not want to handle those duplicates during the analysis.

       

      Example with one XLS/CSV file, the read ones should be ignored while connection to this data source:

       

      TitleTitle2
      aaa1
      aaa2
      aaa3
      bbb1
      bbb2
      bbb3
      aaa3
      bbb2

       

      Example for two different XLS/CSV files, red ones to be ignored:

       

        File 1                                        File 2

      TitleTitle2TitleTitle2
      aaa1aaa9
      aaa2aaa8
      aaa3aaa3
      bbb1bbb9
      bbb2bbb8
      bbb3bbb3