Incremental load

[#1]

Hi,

I have atached script of incremental load. From that I am getting only Qvd data which is history. But I should also get incremented data along with history.

I may went wrong in applying peek function. So please suggest me after looking into the script attached.

Scenario.

I have the data in the Qvd from 2011-Nov-23 to 2012-Dec-02.

In the databsae I have full data i.e upto 2012-Dec-03.

I am not getting output for incremental data i.e for 03-Dec data . Currently I am geting data as there in the QVD. Not incremental happening to add up one more date value.

Kindly respond.

[farolito20]

Ok, thanks.

In this script yo cannot replace your old data whit the new one, you just add the new data keeping the old?

[farolito20]

How I can save the modified data in a table .qvd?

For example, I have an employees_info table and I modified a phone number, but I wanna keep the other number because probably it's ussefull to make an report using old data.

id_employee , name, phone, datemodified

001, carlos, 4556122, 22/06/2011

id_employee , name, phone

001, carlos, 9856741, 24/11/2012

[farolito20]

That's the concept, this is my really script and I have an error

http://community.qlik.com/message/291339#291339

[#5]

Try formatting the ReloadTime function as per your modifydate field.

Sample variables.

LET vReloadTime = ReloadTime();

LET vLastReloadTime = TIMESTAMP(vReloadTime, 'YYYY-MM-DD hh:mm:ss.fff');