Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Incremental reload

Hai,

I don't have the modified and time in my database. Then I tried using the max( sequence no /Transaction no).This option also I cant use because there are multiple sequences.

For Example, they are having different sequence for Tax invoice (TINV00001) and Non Tax invoices (NTINV00003).If I take max(),I'll get any one sequence only.

Is there any other way to do the incremental load?

Thanks in advance..

Tags (1)
2 Replies
mov
Esteemed Contributor III

Incremental reload

There should be some record identifier one way or another...
If really there are none, you can use rule:
max(Tax number) OR max(nonTax number)
Certainly there will be overlap, but you can deal with it later using DISTINCT or EXISTS.

Incremental reload

It's practically impossible to develop a RELIABLE incremental load algorithm without a timestamp or another unique ID... There are techniques of dealing with it on the host database, but those techniques are very intrusive. For example, you (or those developers responsible for the back end database) could develop a set of triggers that would store every new/modified/deleted records in separate tables, giving you the "net change". This is typically more complex than it is beneficial... Ask yourself if you REALLY need the incremental load or if it's just a "nice to do"...

Oleg

Community Browser