7 Replies Latest reply on Mar 16, 2018 6:01 AM by aravind.sunkara

    Updating Data extract

    Hema sekar

      Hello,

         I am aware that Tableau does not support updating or over writing records in data extract if we schedule for Incremental refresh. But, I would like to know whether anyone have any alternative method to achieve this?

      I have huge volume of records in my data extract so I cannot go for full refresh method every time.

      Any help appreciated.

       

      Thanks

      Hema

        • 1. Re: Updating Data extract
          Tracy Rodgers

          Hi Hema,

           

          I'm not sure I understand the desired outcome?

           

          -Tracy

          • 2. Re: Updating Data extract
            Hema sekar

            Hi Tracy,

                Let me explain more on the problem. I have scheduled incremental refresh to my data extract. Thus after every refresh data from tables gets appended to data extract. But whenever there is an update to the table, that is also appended to data extract thus creates two records in my data extract (one before update and one after update).

             

            Table with below columns:

            ID Customer_Name Order_Amt Modified_date

            1  JOHN                  1000         4/3/2013

            2 KEVIN                  2000         4/3/2013

             

            Data Extract after Incremental refresh: ( Refresh scheduled on column Modified date)

            ID Customer_Name Order_Amt Modified_date

            1  JOHN                  1000         4/3/2013

            2 KEVIN                  2000         4/3/2013

             

            When existing record gets updated as below in table from 1000 to 5000 and modified date to 4/4/2013

            ID Customer_Name Order_Amt Modified_date

            1  JOHN                 5000        4/4/2013

            2 KEVIN                 2000         4/3/2013

             

            Data Extract after Incremental Refresh:

            1  JOHN                  1000         4/3/2013

            2 KEVIN                  2000         4/3/2013

            1  JOHN                 5000        4/4/2013

             

            Thus it appends data to extract instead of an update. I wanted to retain only the updated record in the data extract. Any suggestion on this?

             

            Thanks

            Hema

             


            • 3. Re: Updating Data extract
              Hema sekar

              Hi,

                 Any update for my question?

               

              Thanks

              Hema

              • 4. Re: Re: Updating Data extract
                Julius

                Necromancing an old unanswered post, but the interwebs are timeless, so maybe this attachment helps?

                • 5. Re: Updating Data extract
                  Luis Esturban

                  hi,

                   

                  I have the same problem.  I need update data in the extract, not increase the data in the extract, just update alot records with different data.

                   

                  Thanks for your help.

                   

                  Regards

                   

                  Luis

                  • 6. Re: Updating Data extract
                    Umut İşcan

                    Hi, I have the same question.

                     

                    Any comment on this issue?

                     

                    Thanks!

                    • 7. Re: Updating Data extract
                      aravind.sunkara

                      Hi

                      You can try publishing the extract data source to tableau server and try doing a full extract on server daily....