topic Re: Re: Incremental Load Issue in QlikView

Incremental Load Issue

Sun, 20 Apr 2014 11:04:35 GMT

Hi All,

I am trying to use Incremental Load and every time i try to reload the script it gives me an error.

Attached is Data 'Employee1' and QVW is Incremental Load.Also let me know that how can avoid overwriting the saved QVD.

Can anyone help me with this.

Thanks

Ankit

Re: Incremental Load Issue

ashfaq_haseeb — Sun, 20 Apr 2014 11:42:25 GMT

Hi,

Hope it helps,

Please find the attached files,

First time you have to run full load tab by commenting out Incremental tab.

Then comment full load tab and use incremental tab.

If your qvd is corrupted somehow then run full load tab by commenting out incremental tab and then switch back to Incremental tab

Regards

ASHFAQ

Re: Incremental Load Issue

Mon, 21 Apr 2014 05:56:50 GMT

Hi Ashfaq,

Thanks a lot for the help.

Ankit

Re: Incremental Load Issue

Mon, 21 Apr 2014 07:30:03 GMT

Hi Ashfaq,

Also i want you to notice that in Excel file(Employee1) there is another sheet.I want to update the qvd with that data.

Is it possible and how?

Thanks

Ankit

Re: Re: Incremental Load Issue

ashfaq_haseeb — Mon, 21 Apr 2014 07:39:02 GMT

Hi,

Possible, I would here assume that your EMPID is a unique field.

Below code can be replaces in incremental tab.

Employee:

LOAD EMPID,

EMPNAME,

CTC,

Bonus,

Last_Updated

FROM

Employee.qvd

(qvd);

Concatenate

LOAD EMPID,

EMPNAME,

CTC,

Bonus,

Last_Updated

FROM

Employee1.xlsx

(ooxml, embedded labels, table is [Employee Update])

where not Exists (EMPID);

Store Employee into Employee.qvd(qvd);

Let varMaxDate = Num(Peek('Last_Updated',-1,'Employee_Inc'))

hope it helps

Regards

ASHFAQ

Re: Incremental Load Issue

Mon, 21 Apr 2014 09:22:36 GMT

Hi Ashfaq,

Thanks for the reply and apologise to bother again.When i am trying to make changes to Employee Update sheet in Excel and then want to see the changes in the QVD.Its not giving the desired result.

Also when i am trying to apply the above script the =($(varMaxDate)) expression is giving an error.

Thanks

Ankit

Re: Incremental Load Issue

Mon, 21 Apr 2014 11:49:28 GMT

Hi Ashfaq,

Thank you.

It worked Finally.

Thanks

Ankit

Re: Re: Incremental Load Issue

ashfaq_haseeb — Mon, 21 Apr 2014 11:52:45 GMT

Hi,

If it answered your concern, Then mark this question as answered.

As it may help others searching the same issue.

Regards

ASHFAQ

Re: Incremental Load Issue

Mon, 21 Apr 2014 11:52:51 GMT

Hi Ankit,

Find the below attachment Of Incremental Load.

Steps-:

1) If first time you loading the Data then Make Qvd Of Employee Data.(refer QVW Sol1).

2) After that create variable vUpdate For checking data Of Employee date.(refer QVW Sol2 Tab Employee Data)

3) After creating varible then Upload Update Data Of Employee but it will not concatenate with Qvd Data then given where condition new data date is greater than Old data date.(refer QVW Sol2 Tab Incremental Load).

4) Again upload Old data Qvd Of Employee concatenate with update data and give where condition that EMPID field

Dose not Exists because here you EMPID Field made unique field and update the same(Employee) Qvd.(Refer QVW Sol2 Tab Employee Update Data)