2 Replies Latest reply on Mar 28, 2018 5:51 AM by David Maning

    Hard level issue with extract

    David Maning

      Hi friends!

       

      Currently I've faced with a heavy issue regarding the process of refreshing in Tableau.

       

      So, the problem is following:

      Imagine a database with millions of rows. Each row has (among other columns) a unique ID and timestamp of uploading to server. New rows added automatically. However elder rows that have datediff between current date and today equals to 2 are also updated

      Please observe the example of updating process below:

      IndexMeasureDateUpdated
      110025/03/18No
      220024/03/18No
      330027/03/18Yes
      440028/03/18Yes

       

      So, the question is how to update data that follows under 2 days (datediff) condition and add new rows accordingly.

       

      Many thanks in advance for you help!

       

      D