topic history table .qvd in QlikView

history table .qvd

farolito20 — Wed, 12 Dec 2012 22:27:41 GMT

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

Re: history table .qvd

MayilVahanan — Wed, 12 Dec 2012 22:57:17 GMT

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

Re: history table .qvd

farolito20 — Wed, 12 Dec 2012 22:59:48 GMT

but, the incremental load replace de data right?

Re: history table .qvd

MayilVahanan — Wed, 12 Dec 2012 23:05:36 GMT

Fetch the Modified data only. Please refer the ppt .

Re: history table .qvd

farolito20 — Wed, 12 Dec 2012 23:08:51 GMT

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

Re: history table .qvd

MayilVahanan — Wed, 12 Dec 2012 23:14:58 GMT

Please notify it.

If ScriptErrorCount = 0 then

STORE QV_Table INTO File.QVD;

Let LastExecTime = ThisExecTime;

End If

Re: history table .qvd

farolito20 — Wed, 12 Dec 2012 23:17:55 GMT

but thats happen If ScriptErrorCount = 0

when ScriptErrorCount = 0 ?