Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am loading data from a call center and running reports off of it, each new call is logged into a table within an SQL database with a Call ID. At the moment every time the data is reloaded all the data is pulled from the table. I have started to create a append load to only reload "new" data.
How do I specifie to only load new data after the latest time and date previously loaded in the last load?
Here is my current code:
Inbound:
LOAD *
SQL SELECT
FROM Database.Inbound;
CONCATENATE
LOAD * FROM
(qvd);
STORE Inbound into E://Inbound.qvd;
[\code]
I want to say only load new data stored in the Inbound table in the database which hasnt already been loaded? so take the latest time/date loaded in the last load and load new data written to the database after that?
Hope that makes sence.
Cheers, Joe</body>
Have no code on hand, would suggest
HTH
Peter