4 Replies Latest reply on May 9, 2013 7:22 AM by Toby Erkson

    Recovering a deleted item from from a data extract/connection

    Paul Murray

      I surfed the forum and found a similar issue - I tried the save-as twb thing / close-re-open ... to no avail.

       

      Here's what I did and hope never to do again:

       

        Created connection with custom-sql

        Must have - at some time in the evolution of this data set - deleted an item (a measure)

        Despite the sql including this item, the tableau extract does not.

           I have done refresh, even re-ran the query, ....

       

      I'm hoping there's an easy way to get it back ... not only is the query a beast that

      takes about an hour - I have a zillion calc'd items that I stand to lose if I have to create a new

      connection.

       

      Thanks in advance

      Paul

        • 1. Re: Recovering a deleted item from from a data extract/connection
          Robert Morton

          Hi Paul,

           

          This likely means that you have hidden the field in Tableau, and extracts will ignore hidden fields. To determine if this is the problem (and correct it), follow these steps:

           

          1. Right-click on your data source and uncheck "Use Extract"
          2. Right-click in the "Dimensions" window (or click the small drop-down arrow in the "Dimensions" title bar) and choose "Show Hidden Fields".
          3. Does the field you want now appear? If not, then you can ignore the subsequent steps. Contact support to help you investigate the problem. If the field does appear, the steps below will make it usable again.
          4. Right click the field and choose "Unhide".
          5. Re-create your extract.

           

          Does this help?

          -Robert

          • 2. Re: Recovering a deleted item from from a data extract/connection
            .Ryan Christo

            Hey Paul,

             

            I've ran into something similar to this as well. The way I got around it was renaming the field in my custom SQL and rerunning the extract. Most of the time it will reappear in my workbook. Hope that helps.

            • 3. Re: Recovering a deleted item from from a data extract/connection
              Anthony Spalding

              Renaming the field - even changing the case - seems to works if you've deleted the field.  That's because it's now loading a different field, rather than the one it has a deletion marker for.

               

              To fix it without doing this I saved the workbook to a TWB file and then edited it in a text editor (I guess you could use an XML editor).  I searched for the deleted field and deleted the hidden='true' statement in the column tag.

               

              When I loaded the workbook in Tableau the name of the field is back, but it's highlighted in red and marked with an exclamation mark to show that it has no data.  I then refreshed the extract to complete it.

              • 4. Re: Recovering a deleted item from from a data extract/connection
                Toby Erkson

                Nice work guys!  I like your investigative work in the xml file, Anthony.

                 

                Paul, if you get a solution please let us know by marking the thread answered or else by replying.  This goes for any thread you've created.  Thanks