Incremental Load Issue

[#1]

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

[ashfaq_haseeb]

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

[#3]

Hi Ashfaq,

Thanks a lot for the help.

Ankit

[#4]

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

[ashfaq_haseeb]

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

[#6]

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

[#7]

Hi Ashfaq,

Thank you.

It worked Finally.

Thanks

Ankit

[ashfaq_haseeb · Accepted solution]

Hi,

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

As it may help others searching the same issue.

Regards

ASHFAQ

[#9]

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)