Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi
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