Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Modified date and last execution time

i have one doubt how we get modification time and last execution time in implementing incremental load.

modified date will get after trasformations or before let me know how to get last execution time

8 Replies
its_anandrjs

Use last reload date and time like Reloadtime() function and use this date for last execution time.

Let vReloadtime = Reloadtime();

Not applicable
Author

when will be modification time will greater than last execution time

its_anandrjs

Modification time you get from database like where updation dones and then you check that last updation date with last reload time when you reload the application.

Not applicable
Author

Thank u.

Ok. But it will not work to all SAP tables because some tables dont have date and time field.

I got problem in some of the SAP tables like

MSEG,

JEST

KONV

and production related tables.

So, I used incremental load.

Thanks and Regards

Amol Khochare

its_anandrjs

Yes because in SAP if table is cluster table then you are not able to get last modified data easily because it is maintain in different table and it is difficult to give incremental load for the cluster table because it is a combination of the 2 or more tables.

Not applicable
Author

Yes, correct.

If I use deferent fields instead of date and time like document no, item and combi of both etc. whichever is suitable. Will it be work or right way to define incremental load?

Regards

Amol Khochare

its_anandrjs

Yes you are right.

VamsiBhagavathula1

@its_anandrjs  if we use last execution time as with Reloadtime() , That means we need atleast one sucessfull reload for the app otherwise data load gets failed.