How to skip and load the tables

[suryajeganathan]

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?

[Gysbert_Wassenaar]

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.

[Mark_Little]

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

[avkeep01]

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.