I have an invoicing report where I concatenate data from various Excel files and from my internal system through an ODBC link. The Excel files are very big as they have historical invoicing data.
What I want to do in order to make load times faster is to when I use Reload or Partial Reload I only update the part from the system, without reloading these files as I rarely modify them. Any idea on how to do that?
The system data is only the current month's information.
I tried using ADD and REPLACE to this section in my script, but as you can see below (blue bars), ADD just duplicate the data that I had before for this section and REPLACE erases all data (even from the Excel files) and leave only the system data.
You need to use an if statement with the IsPartialReload() function.
With that you can do more than
IF IsPartialReload()=True Then
That way you can do other commands besides just ADD and REPLACE.
You can do a concatenate to an existing table in the datamodel.