Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
in partial reload use of add keyword is "adding new data without loading alltables" AND replace keyword is used for replacing data with existing data? am i right ?
thanks in advance i want only defination pls correct it if wrong
Yes you are correct .
partial load itself means loading a portion of script;
add Keyword is used to load a table first time.
and if table is already loaded then for loading agin that table we can use below
add drop table tab1;
add Load
*
from Path
and
for replace see below
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.
Examples:
Tab1:
Replace load * from File1.csv;
During both normal and partial reload, the QlikView table Tab1 is initially dropped. Thereafter new data is loaded from File1.csv and stored in Tab1.
Tab1:
Replace only load * from File1.csv;
During normal reload, this statement is disregarded.
During partial reload, any QlikView table previously named Tab1 is initially dropped. Thereafter new data is loaded from File1.csv and stored in Tab1.
Tab1:
Load a,b,c from File1.csv;
Replace load a,b,c from File2.csv;
During normal reload, the file File1.csv is first read into the QlikView table Tab1, but then immediately dropped and replaced by new data loaded from File2.csv. All data from File1.csv is lost.
During partial reload, the entire QlikView table Tab1 is initially dropped. Thereafter it is replaced by new data loaded from File2.csv.
Tab1:
Load a,b,c from File1.csv;
Replace only load a,b,c from File2.csv;
During normal reload, data is loaded from File1.csv and stored in the QlikView table Tab1. File2.csv is disregarded.
During partial reload, the entire QlikView table Tab1 is initially dropped. Thereafter it is replaced by new data loaded from File2.csv. All data from File1.csv is lost.
Yes you are correct .
partial load itself means loading a portion of script;
add Keyword is used to load a table first time.
and if table is already loaded then for loading agin that table we can use below
add drop table tab1;
add Load
*
from Path
and
for replace see below
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.
Examples:
Tab1:
Replace load * from File1.csv;
During both normal and partial reload, the QlikView table Tab1 is initially dropped. Thereafter new data is loaded from File1.csv and stored in Tab1.
Tab1:
Replace only load * from File1.csv;
During normal reload, this statement is disregarded.
During partial reload, any QlikView table previously named Tab1 is initially dropped. Thereafter new data is loaded from File1.csv and stored in Tab1.
Tab1:
Load a,b,c from File1.csv;
Replace load a,b,c from File2.csv;
During normal reload, the file File1.csv is first read into the QlikView table Tab1, but then immediately dropped and replaced by new data loaded from File2.csv. All data from File1.csv is lost.
During partial reload, the entire QlikView table Tab1 is initially dropped. Thereafter it is replaced by new data loaded from File2.csv.
Tab1:
Load a,b,c from File1.csv;
Replace only load a,b,c from File2.csv;
During normal reload, data is loaded from File1.csv and stored in the QlikView table Tab1. File2.csv is disregarded.
During partial reload, the entire QlikView table Tab1 is initially dropped. Thereafter it is replaced by new data loaded from File2.csv. All data from File1.csv is lost.