Incremental Load problem.

agni_gold — Sat, 19 Apr 2014 13:07:22 GMT

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 .

Re: Incremental Load problem.

agni_gold — Sun, 20 Apr 2014 11:30:43 GMT

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.

topic Re: Incremental Load problem. in QlikView

Incremental Load problem.

Re: Incremental Load problem.