Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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!
Hope this will work fine.
Srinivas did you got the solution ?
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!