Examples of Include in Clear Data Loads
  • 1 Minute to read
  • Dark
    Light
  • PDF

Examples of Include in Clear Data Loads

  • Dark
    Light
  • PDF

Article summary

Here are some examples of what happens with your existing data when you load new data into an External Source Model, using the Include in Clear Data checkboxes on the Define Overall Rule Settings section of the Data Load Rule.

Before the data load, here is the existing data.

ModelingImagesEDSMESMDLRIncludeinClearOriginalData1.png

Here the new data to be loaded.

ModelingImagesEDSMESMDLRIncludeinClearLoadData1.png

Example 1: Include in Clear Data is checked for the Department column

When the Department field is checked, the DLR examines the new data load file to see which Departments are in it. In this case, the load file uses only one department: FIN. All data in the existing ESM with Department FIN is then cleared before the new data is loaded.

The resulting data is as follows.

ModelingImagesEDSMESMDLRIncludeinClearEx11.png

Example 2: Include in Clear Data is checked for the Department and Company columns

When the Department and Company fields are checked, the DLR examines the new data load file to see which combinations of Department and Company are in it. In this case, the load file uses the following combinations: 1010 FIN. All data in the existing ESM with Company 1010 and Department FIN is then cleared before the new data is loaded.

The resulting data is as follows.

ModelingImagesEDSMESMDLRIncludeinClearEx21.png

Example 3: Include in Clear Data is checked for all columns

When all fields are checked, the DLR examines the new data load file to see which fields have common values amongst all the rows. 

Note:
Thus if there is any data in the existing ESM with the same values, those will be deleted and the data with new values will be added.

The two new records are loaded. The resulting data is as follows.


Was this article helpful?