Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
qlikview979
Specialist
Specialist

Partial reload

Hi experts,

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

2 Replies
Chanty4u
MVP
MVP

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