Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
Highlighted
suryajeganathan
New Contributor III

How to skip and load the tables

Hi

I have three tables in Data loader,I don't have any update an the first table and i just want to refresh the remaining two tables .

I don't have any data field to put the where condition too in the table & Is it possible to skip the first table and load the remaining two tables?

Tags (1)
3 Replies
MVP & Luminary
MVP & Luminary

Re: How to skip and load the tables

Yes and no. It requires a partial reload and you need to use the API's for that. Unless you're talking about hours of reload time I'd simply load all three tables. Or store the unchanged table into a qvd and load it from the qvd in consequent reloads. Qvd's load very fast.


talk is cheap, supply exceeds demand
Partner
Partner

Re: How to skip and load the tables

Hi

Depending on your full requirements you may be able to achieve what you need by using sub routines.

https://help.qlik.com/en-US/sense/September2018/Subsystems/Hub/Content/Sense_Hub/Scripting/ScriptCon...

If you wrap each of your loads in a sub function, when you then call your sub routines you can add an if statement that only loads the  required tables.

Mark

Partner
Partner

Re: How to skip and load the tables

In addition to Gysberts comment:

You can als use IF statements in the script. So in in that case you can manually configure the script to load QVD data or data from the source. Like this

LET vLoadQVD = 1;

IF FILETIME('Path\QVDNAME')>0 AND $(vLoadQVD) 1 THEN

Table:

LOAD * FROM QVD;

ELSE

Table:

LOAD * FROM Source;

STORE Table into QVD;

END IF

I also made an escape for the case when the QVD is missing.