topic Re: How can I trigger a 'first reload' for an app in Connectivity & Data Prep

How can I trigger a 'first reload' for an app

tevkar1 — Mon, 26 Feb 2024 14:57:32 GMT

Hi,

Trying to update/upgrade Sessions monitor ....

When I click Load Data from Data Load Editor, it tells me that the load happens incrementally.

Incremental reload (not first reload)

Any chance to trigger for a first/initial realod ?

Kind regards

Re: How can I trigger a 'first reload' for an app

PhanThanhSon — Mon, 26 Feb 2024 15:27:30 GMT

Hi,

i would do it like this way:

Set vLoad = 0;

IF $(vLoad) = 1 then
InitialReload:
LOad * Inline [
A, B,C
1,2,3
];

ELSEIF $(vLoad) = 0 then

IncrementalLoad:
LOad * Inline [
A, B,C
3, 4, 5
];

END IF

Or try a partial reload:

https://help.qlik.com/en-US/sense/February2024/Subsystems/Hub/Content/Sense_Hub/Scripting/ScriptPrefixes/PartialReload.htm

https://www.youtube.com/watch?v=QuQdWOCUwjo

Best regards Son

Re: How can I trigger a 'first reload' for an app

tevkar1 — Wed, 28 Feb 2024 08:23:11 GMT

Following has worked for me:

Update Sessions Manager -> load_base_table

// Check to see if governanceLogContent qvd exists // Let baseFileSize = FileSize('$(archivo).qvd'); Let baseFileSize = 0;

Run Load Data
Roll back to the original code

// Check to see if governanceLogContent qvd exists Let baseFileSize = FileSize('$(archivo).qvd');