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

[ashok1203]

Hi Sri nivas, Try to use the below link it might some helpful to you.

https://www.analyticsvidhya.com/blog/2014/09/qlikview-incremental-load/‌

If it is not, let me know.

[konidena]

Hi Ashok,

I followed this approach already. It is not helpful.

My scenario is

New file has 102 records. In that, 70, 71, 72 are updated with new salary.

Incremental Load - Update scenario is not working here as expected.

Regards

Srinivas

[marcus_sommer]

Take a look here: Slowly Changing Dimensions.

- Marcus

[ashok1203]

Can you provide the sample table structure to understand it clearly.

[Anil_Babu_Samineni]

How is your script looking

And have you update the value from excel? If yes, why do you require the incremental load. Would you elaborate more

Because, if you update from excel it should choose one you reload from script. Have you created qvd for before updating?

[shraddha_g]

With this data you can add one more column for "last updated on"(Date field).

And then you can use this field in incremental load.

by this you can also track updated as well as newly added records.

I hope this is helpful.

[adamdavi3s]

Do you mean that you are adding rows when changing data?

i.e. there are now two rows for 70?

If so then can you just rowno() the import then only bring in the row with the max rowno() for each record?

[konidena]

Hi Anil,

First i have extracted the data from excel to qlikview.

Number of rows are 100.

Later, the excel has updated with 2 more new rows and also there is an update in the salary for the records of the Employee ID: 71, 72, 73.

How to get the new info according the new updates

Regards

Srinivas

[adamdavi3s]

Why are you not just reloading the spreadsheet to overwrite the data?

Do you need to record the old data?

If so then load the date/time as you load the spreadsheet, then map this to your data