Thanks for the advice, but my source table and the update table doesn't meet the following attributes.
To utilize Incremental Load a source table must have both of the following attributes:
- A unique identifier — a Primary Key — for each row.
- A “Modification” column that identifies when a row was added or updated. The column type may be a Date, Datetime or ascending Revision number.
Is there any way to add these primary keys & modification collumns to my source table in qlikview? Its about 4million entrys long, so I cant edit it in excel.