Partial reload

qlikview979 — Thu, 25 Jun 2015 17:34:58 GMT

Hi experts,

What is partial reload? what is use of Add,Add only,Replace ?

Re: Partial reload

Chanty4u — Fri, 26 Jun 2015 02:26:09 GMT

hi,

Executes the current load script, including all script commands, such as

Drop Table , and reloads data to the active QlikView document.

However, only those tables whose load and select statements are preceded

by the Replace or Add prefix are reloaded. Data

tables that are not affected by this kind of load or select statements will not

be affected by the partial reload. This command can also be invoked by the

following keyboard shortcut: Ctrl+Shift+R.

Replace:

the replace prefix can be added to any Load , Select (SQL) or Map ... using statement in the script. The replace load/replace select statement has the effect of dropping the entire

QlikView table, for which a table name is generated by the replace load/replace select statement, and replacing

it with a new table containing the result of the replace load/replace select statement. The effect is the

same during partial reload and full reload. The replace map...using statement causes mapping to take place

also during partial script execution.

The syntax is:

replace[only](loadstatement |selectstatement |map...usingstatement)

where:

only is an optional qualifier denoting that the statement should be disregarded during normal (non-partial)

reloads.

ADD:

The syntax is:

add [only] (loadstatement |selectstatement |mapstatement)

where:

only is an optional qualifier denoting that the statement should be disregarded during normal (non-partial)

reloads.

Hope this helps you

Thank you

Suresh

topic Partial reload in QlikView

Partial reload

Re: Partial reload

Re: Partial reload