3 Replies Latest reply on May 22, 2017 9:54 AM by Mark Pesce

    Data extract is adding previously removed fields?

    Mark Pesce

      Has anyone seen this before? I have some extracts built off of a published data source on my Tableau server. Whenever a refresh (incremental or full) is performed, a subset of fields get added to the extract. These fields do actually exist in the published data source, but they don't appear on the correct table. I have deleted these fields and performed a full refresh and they appear again. None of these fields are used in the workbook and when I build the extracts I select "Hide Unused Fields"...yet they keep appearing. I've even tried deleting the TDE file and started with a new one and it keeps happening.


      This is more of a nuisance than anything else, but I was just curious to see if this was happening with anyone else. We just upgraded to 10.2.1 for Desktop and Server.

        • 1. Re: Data extract is adding previously removed fields?
          Patrick Van Der Hyde

          Hello Mark,


          Is the extract refresh in question the one that Tableau Server is doing?   What sort of data source is it hitting?   You might want to review the Performance portion of Tableau Server Help for assistance to better understand what's happening under the covers.  - Performance




          If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution.  Thank you.

          • 2. Re: Data extract is adding previously removed fields?
            SANDIP SHARMA

            HI Mark,


            No worries you can fix this problem use below steps.


            Download your published extract and open the same in Tableau Desktop and delete all unwanted field which you want to delete and overwrite the same with published one.


            And try to refresh the same again.


            But make sure you above steps will works only if your are using table directly in tableau then its fine other wise check your custom SQL code or view or Stored Proc and check whether these are having those columns which were adding to your extract automatically after each refresh. If they really exist in view/custom SQL/Stored Proc then please comment those files accordingly and republish the same and try to refresh it again you will get only those fields which you want now.

            4 of 4 people found this helpful
            • 3. Re: Data extract is adding previously removed fields?
              Mark Pesce

              To clarify, I am building an extract that is created from a data source stored on my Tableau Server. These are valid fields for other workbooks, but not for this particular extract. The refreshes I was performing from the earlier in the thread were happening in Desktop and Server.


              As was previously stated, this is more of a nuisance than anything else.