Forum Discussion
append local table and save
Good evening, I have data stored on an SQL server Once per day l Ioad various database tables which i then manipulate and store in a single pivot table (say X). I would like to append the pivot...
Sounds like a use case for the Preview feature for Incremental refresh. There are ways to use Append query to do this manually but it takes manual intervention. Is there a reason you can't just refresh the entire table?
the pivot table contains one row which include numbers for leads, registered rfq, rfq,s being worked on, issued rfq,s etc.
the other table, the one i would like to append on a daily basis, stores these rows.
so purpose is to build a history
data comes from a microsoft dynamic navs 2017 database btw.
thx