Forum Discussion
Append into Historic table without deleting previous rows
Hello, I have 2 tables; 1 for current data and 1 for historic data. I would like to "append" the current data into the historic data table, WITHOUT deleteing the previous rows. When i use Append, ...
If your spreadsheets are time based (i.e., filename has text that can be converted to date), you can leverage incremental refresh to greatly speed up your refresh. See this video for the general approach.
https://www.youtube.com/watch?v=IVMdg16yBKE
Pat
I appreciate the quick response, but that is not what i am looking for. my files update weekly.
This looks to be only updating the published report. i would like to see this data in the desktop dashboard / tables everytime it is opened.