Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

Incremental Load without date feild

Can any one tell me how to perform incremental load when there is no date feild  but key feild is present?????????

Plz explain with example in case

1) Update

2) Insert

3) Delete..

8 Replies
Highlighted
MVP
MVP

Re: Incremental Load without date feild

Unless until you have some timestamp to check for latest updated data, you can't implement incremental load with key field only. Possibly you can handle the Insert Only and Delete Only cases with Key field, but that might not be really incremental.

Highlighted
Not applicable

Re: Incremental Load without date feild

If u dont hv Date field..

Example:

Load

a,b,c

From Source..

Store Example into Example.qvd;

In second time load it will clear old qvd & generate new qvd..

without date it will refresh qvd..no incremental.

Highlighted
MVP & Luminary
MVP & Luminary

Re: Incremental Load without date feild

Is your key field an ascending value? Does your table have only inserts, not updates?

-Rob

Highlighted
Not applicable

Re: Incremental Load without date feild

Hello,

here are a simple example without a date field.

Not perfect but shows in principal how it could work.

Good luck!

Rainer

Highlighted
Contributor III
Contributor III

Re: Incremental Load without date feild

i want to update as well insert and delete in one table

Highlighted
Contributor III
Contributor III

Re: Incremental Load without date feild

can i do it with trigger ???????????

if yes plz expalin with example.

Highlighted
Contributor III
Contributor III

Re: Incremental Load without date feild

suppose id are not seqential i.e

1 3 5 8 9 12 

and then you insert id 2 , how it will work??????????/

Highlighted
Not applicable

Re: Incremental Load without date feild

That does not matter as long as you have a unique identifier. ID. the id's should be ascending. The principle is similar to when you have a timestamp: identify your delta and load them.