Hopefully this is easy question to solve - I'm periodically load a bank update file with two tables into QS. The Account Summary: table just holds [account name] and [balance] fields as at the last download date. (The other table is transactional data which I'm fine with).
When I reload the file I simply want to add to rather than replace the [account name] and [balance] data so I can visualise account balance over time.
I also need to create a automated date field in the load script as the download date is not provided in the raw data.
I tried to do some stuff with incremental loads but it all got a bit confusing - surely this cant be that difficult!
Sorry I'm a newbie, can someone pls help me with a simple solution!