How to do a partial reload.

[#1]

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.

[sridhar_sigired]

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

1. ScriptStatementsAndKeyWords.xlsx

(ooxml, embedded labels, table is Persons);

/* This statement works at normal reload and partial reload */

Add

LOAD Name,

    Number

FROM

1. ScriptStatementsAndKeyWords.xlsx

(ooxml, embedded labels, table is NewPersons)

;

// This statement works at partial reload

Add Only

LOAD Name,

    Number

FROM

1. ScriptStatementsAndKeyWords.xlsx

(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