history table .qvd

[farolito20]

How I can save the modified data in a table .qvd?

For example, I have an employees_info table and I modified a phone number, but I wanna keep the other number because probably it's ussefull to make an report using old data.

id_employee , name, phone

001, carlos, 4556122

id_employee , name, phone

001, carlos, 9856741

[MayilVahanan · Accepted solution]

Hi

Try with Incremental load

http://community.qlik.com/message/198178#198178

For understand incremental load

http://community.qlik.com/message/208263#208263

Hope it helps

[farolito20]

but, the incremental load replace de data right?

[MayilVahanan]

Hi

Fetch the Modified data only. Please refer the ppt .

[farolito20]

ok..

Let ThisExecTime = ReloadTime();

QV_Table:

SQL SELECT PrimaryKey, X, Y FROM DB_TABLE

WHERE ModificationTime >= #$(LastExecTime)#                

       AND ModificationTime < #$(ThisExecTime)#;

Concatenate LOAD PrimaryKey, X, Y FROM File.QVD

WHERE NOT EXISTS(PrimaryKey);

Inner Join SQL SELECT PrimaryKey FROM DB_TABLE;

If ScriptErrorCount = 0 then

  STORE QV_Table INTO File.QVD;

  Let LastExecTime = ThisExecTime;

End If

what's the value of #$(LastExecTime)#           ?

[MayilVahanan]

hi

Please notify it.

If ScriptErrorCount = 0 then

    STORE QV_Table INTO File.QVD;

    Let LastExecTime = ThisExecTime;

End If

[farolito20]

but thats happen If ScriptErrorCount = 0

when ScriptErrorCount = 0 ?