topic Re: Create historic table based on changes on field in QlikView

Create historic table based on changes on field

Thu, 06 Aug 2015 11:53:28 GMT

Hi,

Background:

Table 1:

ID	Name	Status
1	test 1	TBD
2	test 2	TBD

Historic data of Table 1:

Table 2:

ID	Change Date	Status
1	01/08/2015	Change

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

Hope someone can add some insight with an example.

Thanks,

sunny_talwar — Thu, 06 Aug 2015 11:57:08 GMT

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???

Thu, 06 Aug 2015 12:07:49 GMT

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.

Thu, 06 Aug 2015 14:27:00 GMT

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