Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
alan_grn
Creator II
Creator II

Retention of loaded table when running script.

Is it possible to retain a pre loaded table when running a script?

If possible I would like to retain a table without having to reloaded it from source files when I run a full load.

3 Replies
blaise
Partner - Specialist
Partner - Specialist

Have a look at the addload, partial reload and resident load.

alan_grn
Creator II
Creator II
Author

I have tried to use the resident load but have not got it to work.

If the table is table1, what is the syntax in the script fi I want to keep table1 and not lose it when I run a load script.

I have tried Load * resident table1, but get an error.

hectorgarcia
Partner - Creator III
Partner - Creator III

if the table you want to keep is a slow changing table you can use buffer.

I.E, this table values will be kept for 10 days in buffer after the first reload with the buffer fucntion



buffer (stale after 10 days)
LOAD TaskUID,
TaskParentUID,
ProjectUID,
TaskName,
text( "WBS Code") as "WBS Code",
"Task Status";
SQL SELECT *
FROM "ProjectServer6516_Reporting".dbo."MSP_EpmTask_UserView";

I hope this is what you need