Partial Reload - QlikView Tutorial - Session 13

Опубликовано: 28 Сентябрь 2024
на канале: In Music Vibes
620
2

In this session you will learn about Partial load

Partial Reload
--------------------
- Instead of executing entire script, If we want to execute only particular portion of the script, we need to Perform Partial Reload
- To Perform Partial Reload, Give 'Add' Qualifier before LOAD or SELECT Statement
- To separate normal Reload with Partial Reload, Give 'Add Only' Qualifier before LOAD or SELECT Statement

Add Only LOAD * Resident Products Where not Exists(ProductID);

- By using Partial Reload, We can Replace one Table data with another Table Data
- To perform Replace two tables must contain same set of fields
- 'Replace' or 'Replace Only ' Qualifiers before LOAD or SELECT Statement