Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everybody. I have a little question.
How to make partial reloads? I´ve read a lot of articles explaining what they are, and when we have to use them but i didnt found a simple explanation
Thank you all.
Partial Load:
Add: Add is prefix for Load, Select and Map statements. "Add load" statement will execute at normal & partial load. But "Add only load" statement executes only at partial load. It will not check for any duplicates at normal load, but it will checks at partial load
Replace: Replace will replace the previous loaded table and adds the new table with data. It will work at normal and partial load. In normal reload it will load the first table and immediately it will drop the first table, then it will load the replace table along with data. In partial reload it will drop the first table and loads the replace table along with data.
Eg:
If you have data
Persons:
Name | Number |
Jagan | 1 |
Sri | 2 |
New Persons:
Name | Number |
Jagan | 1 |
Sri | 2 |
X | 3 |
Y | 4 |
Table1:
LOAD Name,
Number
FROM
(ooxml, embedded labels, table is Persons);
/* This statement works at normal reload and partial reload */
Add
LOAD Name,
Number
FROM
(ooxml, embedded labels, table is NewPersons)
;
// This statement works at partial reload
Add Only
LOAD Name,
Number
FROM
(ooxml, embedded labels, table is NewPersons)
Where not Exists(Name)
;
Try to comment each statement one by one and check with reload and partial reload based on exampl