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

    Examples of Include in Clear Data Loads

    • Dark
    • 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?