Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
agni_gold
Specialist III
Specialist III

Incremental Load problem.

Hi All,

I have a problem regarding incremental load on my attached excel file.

I have following fields in my excel :

Employee Id               Varchar

Employee Name         Varchar

Created Date              Date

Modified Date             Date

Created By                Varchar

Modified By               Varchar

Active Flag                Varchar

I want to apply incremental load on Employee ID (Must Requirement) . And Have following conditions :

1 Incremental should be on Employee Id field.

2. New Emplyee Added with Created Date and Modified Date with , that day when it was created.With Active Flag Y

3. And if any employee deleted from previous data , then in QVD file i want that data with Modified Date as same date on which it was deleted with active flag N. Means i want to maintain the history data.

i am attaching my Excel file .

1 Solution

Accepted Solutions
agni_gold
Specialist III
Specialist III
Author

i have found this solution from my self.

You can fine the solution file at

Incremental Load.qvw

Also attaching the QVS file for those who have personal edition.

Thanks all.

View solution in original post

1 Reply
agni_gold
Specialist III
Specialist III
Author

i have found this solution from my self.

You can fine the solution file at

Incremental Load.qvw

Also attaching the QVS file for those who have personal edition.

Thanks all.