Skip to main content

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
suryajeganathan
Contributor III
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?

3 Replies
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.


talk is cheap, supply exceeds demand
mark6505
Partner - Master
Partner - Master

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
Partner - Specialist
Partner - Specialist

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.