Discussion board where members can get started with QlikView.
I need to do incremental load. But I do not have data column and primary key. Also, I am not able to a unique column out of the combination of different columns. Can anyone please help me in this regard.
Incremental always needs either a date field or a primary key. Without these i think it wont be possible to identify new records in the database.
Please see: https://www.analyticsvidhya.com/blog/2014/09/qlikview-incremental-load/
This could be helpful
Hope this thread will help you.
We can generate or set flag to incorporate incremental load in your scenario. Can you provide us any sample data.
And on what basis your incremental load should work ? I mean like hourly basis, daily basis, weekly basis or for every reload ?
may be helpful for you?
Incremental Load without Date field
It would be on daily basis. I am sorry as I cannot provide a sample data since it is client specific. Thanks in advance
Can you please elaborate this FLAG concept through an example. Thanks