2 Replies Latest reply on May 31, 2015 8:42 PM by Nicholas Hannan

    Creating extract data causes duplicate issues

    dieter.bahlmann

      Good day,

       

      We just upgraded to Tableau 9.0.1. and since then I'm having an issue with duplicate members when using extract data.

       

      In my data source I have 3 members in the dimension called OperatorName namely "Blaauw, Willem", "Willem" and "willem".

       

      When using no extract, Tableau only shows 2 members as shown below:

      image1.png

      However, when I create an extract data Tableau shows all 3 members from the data source as shown below. What is causing this difference in handling the data?

      image1.png

      Furthermore, when I group above 3 members into an alias using Tableau Groups and then refresh the Extract, Tableau gives the error "Removed 1 duplicate members from the group". After refreshing the Extract again, one of the "willem" variants sits outside the grouped alias as shown below. Is this a bug in the new version?

      Group 2.png

      Kind Regards

      Dieter

        • 1. Re: Creating extract data causes duplicate issues
          dieter.bahlmann

          Hello,

           

          Below workbook illustrates my problem.

           

          1. Created extract data;

          2. Create Group as shown below;

          IMG1.png

          3. Extract data... and below errors comes up;

          error.png

          4. Click OK and Extract data again results in below grouping of members;

          IMG3.png

          5. Remove extract results in below grouping

          IMG4.png

           

          This was certainly not an issue in previous versions and is no causing problems on my existing reports with large data sources.

           

          Kind Regards

          Dieter

          • 2. Re: Creating extract data causes duplicate issues
            Nicholas Hannan

            Hi Dieter,

             

            I was able to reproduce the issue you experienced. I was not aware of this but I did find an explanation for you:

             

            Tableau extract is case sensitive

             

            It is definitely possible Tableau made changes to the data engine which provide better support for case-sensitivity in Extracts with 9.0, but you may want to contact support for a definitive answer on this one.

             

            To get around this, you may need to normalize your strings before bringing them into Tableau if you're data-entry side is not that consistent.

             

            Best regards.

            1 of 1 people found this helpful