Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

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,

Tags (1)
3 Replies
sunny_talwar
Not applicable

Re: Create historic table based on changes on field

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

Re: Create historic table based on changes on field

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

Re: Create historic table based on changes on field

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