7 Replies Latest reply on Jun 20, 2018 3:26 AM by mortenbodaugaard.jrgensen

    Incremental load mechanisam for updated and deleted records

    Sridhar Sigireddy

      Hi Experts,

       

      This is my first post and i have learned tableau recently and planning to use for my projects.

       

      We have the data (in SQL Server) which updates frequently (we get updated data for historical data) and we can track this using updateddatetime field from tables. We do not prefer live connection for our reporting and prefer extract, so here is the question.

       

      How can we reflect updated or deleted records information in extract while refreshing? As we do not have direct option to do this either in server or desktop, i would like to get some help from someone who implemented by writing a code (in case custom squeal) or any other way to do it?

       

      Regards,

      Sridhar S