Incremental Load

[konidena]

Hi Team,

I am doing the incremental load.

First I have 100 rows of data in excel.

EmpNo, Names, Salary

EmpNo is the Unique id to perform my Incremental load.

Question:

Now I have updated Salary of the EmpNo 70, 71, 72  and added two new EmpNo: 101, 102.

When I am doing the addition of this two new Hempen, I am able to do successfully.

But, I am not able to get the updated records of the EmpNo 70, 72, 73

How to perform Incremental Load in this type of scenarios?

Regards

Srinivas

[Anonymous]

Hi Sri,

Load first your excel, and then, load your QVD With this condition

WHERE Not(Exists(EmpNo))

Then Save your QVD.

You don't have a date field to compare the update, then, the most simple way is load new data and load old data that don't exists on new data.

Regards!

[ashok1203]

Hope this will work fine.

[ashok1203]

Srinivas did you got the solution ?

[Anonymous]

A note on my review, this procedure only works if you haven't loaded previously any field called EmpNo, if you have a loaded previously a field that is so called EmpNo this will not work.

In that case, when the you load the Excel file, you have to create a new field  as this

"EmpNo as EmpNoAux"

and the condition when loading the QVD has to be

WHERE Not (Exists (EmpNoAux, EmpNo))

Regards!