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: 
Not applicable

Create historic table based on changes on field

Hi,

Background:

Table 1:

IDNameStatus
1test 1TBD
2test 2TBD

Historic data of Table 1:

Table 2:

IDChange DateStatus
101/08/2015Change

How can i join or concatenate additional data (Historic) to Table 2 based on change date. So historic table looks like

IDChange DateStatus
101/08/2015Change
107/08/2015Passed
207/08/2015Change

Hope someone can add some insight with an example.

Thanks,

3 Replies
sunny_talwar

I am not sure I understand, how did you arrive at the two new rows you added to your Historic Table??? Where is that information coming from???

Not applicable
Author

The rows should populate based on record change. Means if record gets changed then i would like to keep both status into same table. Like snapshot.

Not applicable
Author

Any insight how to build snapshot of the data if field value gets changed?