Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi experts,
What is partial reload? what is use of Add,Add only,Replace ?
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
Its better to see the video to learn more with basic understanding.
Refer Partial Reload in QlikView – Part I - QlikView Blog, QlikView Videos and Tips at QlikShare
and
Partial Reload in QlikView – Part II - QlikView Blog, QlikView Videos and Tips at QlikShare
Regards,
Siva