topic Re: Incremental load in QlikView

Incremental load

Tue, 04 Dec 2012 12:28:07 GMT

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.

Re: Incremental load

Tue, 04 Dec 2012 14:10:06 GMT

Hi,

As it really helps a lot if I can get the solution from community. Awaiting for the response. \

Thanks in Advance.

Re: Incremental load

gandalfgray — Tue, 04 Dec 2012 15:43:13 GMT

So what does the vIncrementalExpression variable contain?

What do you get when you use that where clause directly in sql?

Re: Incremental load

Tue, 04 Dec 2012 16:38:19 GMT

where clause wil get the results of those records which are new data. In my case it is 03-Dec-2012 data.In the script u can see. I am comparing timemodified of db table with maxloaddate of qvd.

Re: Incremental load

farolito20 — Thu, 13 Dec 2012 14:09:15 GMT

Do you resolve that?

I have the same problem

Re: Incremental load

Thu, 13 Dec 2012 15:13:24 GMT

I have slightly changed the script as per my requirement. Hope the attached script will help.

Re: Incremental load

Thu, 13 Dec 2012 15:15:15 GMT

Sorry forgot to attach file early.

Re: Incremental load

farolito20 — Thu, 13 Dec 2012 15:15:16 GMT

The same script at the first post?

Re: Incremental load

Thu, 13 Dec 2012 15:16:53 GMT

No. Its different. But it solved my problem. Its insert and update method of incremental.

Re: Incremental load

Thu, 13 Dec 2012 15:18:27 GMT

Its insert and update method of incremental. The script posted now and earlier are different. The recent posted script solved my issue.

Re: Incremental load

farolito20 — Thu, 13 Dec 2012 15:18:27 GMT

Ok, thanks.

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

Re: Incremental load

farolito20 — Thu, 13 Dec 2012 15:22:12 GMT

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

Re: Incremental load

farolito20 — Thu, 13 Dec 2012 15:23:16 GMT

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

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

Re: Incremental load

Fri, 14 Dec 2012 06:18:19 GMT

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');