Keep records

[smilingjohn]

Hi All, 

I have table called jira which has  below mentioned fields in the screenshot . So the field "Status and Comments" will keep updating and it will change . But My requirment is to keep the status and Comments as it was before.  how can i achive this ?

Can you please help on this how to achive ?

[MayilVahanan]

HI @smilingjohn 

We can store the current values in qvd and append the future values in the same qvd instead of replace from the source table. 

So that, we can see all the current & future comments in the qvd.

[smilingjohn]

@MayilVahanan  Thnaks ,

But how should we do it in the script ? can you please give me a example on this , It would be really helpful . 

[smilingjohn]

Hi community

Any help on this 

[MayilVahanan]

Hi @smilingjohn 

Sample Script:

If not Isnull(QvdCreateTime('T1.qvd')) then
Load * from T1.qvd(qvd);
ENDIF

T1:
LOAD *
FROM
Sourcetable;

store T1 into T1.qvd;

it will concatenate all the source values in to QVD each times of reload the values.
You can change the script based on ur business logic.