Store variables to QVD

[evgeniystuchalk]

Hello! I want to save some logs about load script. All information accumulated in variables. After script execution i want save this variables in qvd.

For first load, i whrite this:

UpdateLog:

load

now() as UpdateStart,

now()-$(vStart) as amoUpdateTime,

$(vCompleteReload) as ReloadMode;

store notes into [Lib://QVD (win-lng2sl4osbd_qlik.acc)/amoCRM/amoUpdateLog.qvd] (qvd);

but its don work. what to do?

[danansell42]

At what point does it fail?

I notice you have said "store notes" whereas the table name appears to be UpdateLog

Maybe this is the problem?

[evgeniystuchalk]

I have noticed that im trying save wrong table. But "store notes" is not a reason. Debugger stops here:

[danansell42 · Accepted solution]

Maybe because there is no 'FROM' statement

Try adding AutoGenerate 1 at end of statement.

UpdateLog:

load

now() as UpdateStart,

now()-$(vStart) as amoUpdateTime,

$(vCompleteReload) as ReloadMode

AutoGenerate 1;

store UpdateLog into [Lib://QVD (win-lng2sl4osbd_qlik.acc)/amoCRM/amoUpdateLog.qvd] (qvd);