Discussion Board for collaboration on QlikView Scripting.
Historic data of Table 1:
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.
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???
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.
Any insight how to build snapshot of the data if field value gets changed?