topic Retention of loaded table when running script. in QlikView

Retention of loaded table when running script.

alan_grn — Fri, 05 Mar 2010 10:42:48 GMT

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.

Retention of loaded table when running script.

blaise — Fri, 05 Mar 2010 10:55:59 GMT

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

Retention of loaded table when running script.

alan_grn — Fri, 05 Mar 2010 12:31:37 GMT

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.

Retention of loaded table when running script.

hectorgarcia — Fri, 05 Mar 2010 13:54:22 GMT

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