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:
So, the question is how to update data that follows under 2 days (datediff) condition and add new rows accordingly.