I need help in doing incremental load using two fields. The scenario that I have here is as follows,
There are two fields in the database say, "ID" and "STATUS". All these days I was doing the incremental load using the ID field, i.e., to load only the IDs which are greater than the ones loaded in the previous load already.
But the issue here is, it is possible that we have multiple rows with same ID, but different STATUS. So in this case, if a particular ID is already loaded into QlikView and a new row for the same ID is added with a different STATUS, then this will not be updated in QlikView as the ID would have already been loaded into QlikView. Hence, I am trying to do incremental load based on both the fields.
So, for example if we have the following records loaded into QlikView,
Incremental load logic should be like, for a particular ID, load the record with highest STATUS value for that ID. So in my example above, for ID 2, the second record has to fetched since the STATUS value here is highest among all for ID 2.