Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
jasmina_karcic
Creator III
Creator III

Incremental load- how to keep history

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

Labels (1)
  • SaaS

1 Reply
Kashyap_R
Partner - Specialist
Partner - Specialist

Hi

Go through this link

https://help.qlik.com/en-US/sense/November2019/Subsystems/Hub/Content/Sense_Hub/LoadData/use-QVD-fil...

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

Thanks and Regards
Kashyap.R