Incremental load- how to keep history

jasmina_karcic — Mon, 20 Dec 2021 21:38:40 GMT

Hi experts,

As always I need a help from, I hope this time also I will find it here.

I have one table, that is like a dimension in a star scheme. It contains information about clients, like ID number, name, address, and others...

For every client we have employer who is working with him. When employer change, we must change his ID number in a database.

I don't have a way to make some historical table in a database, where I will put date of change.

Is there any options in Qlik, in data load editor, how can I make it?

For example:

On last execution was row:

name surname address info employer_id

Jasmina Karcic City 20. 321 1392

Before next execution, someone make change on this and now on database become:

name surname address info employer_id

Jasmina Karcic City 20. 321 1456

I want have this on next execution, but keeping last, but with information about when change started.

Thanks

Jasmina

Re: Incremental load- how to keep history

Kashyap_R — Wed, 12 Feb 2020 18:53:33 GMT

Go through this link

IF you want to save the old records and when the records have been updated you can use this

Load A, B, C

from X1;

Concatenate

Load A, B, C, Today() as Modified Date

from X2;

Hope this helps

Thanks