[]
        
(Showing Draft Content)

Overwrite Data

After creating a data source, you can manage it in the portal. You can upload new Excel data to completely overwrite the previous data with the help of the Overwrite Data option as shown below.

overwrite-data-option


Important Points

  • You can overwrite only the local Excel data source.

  • The new Excel data should be identical to the previous data structure.

  • The Excel file used for overwriting should have the same password as when the Excel data source was created.

  • After performing an overwrite operation on a data source, revisions on the Info page will not retain the history.

Steps to overwrite an Excel data source

In this example, we will add a new Customer Id (8) in the Excel and overwrite the existing Excel.

Before overwriting, the data is as shown below.

before overwrite

We have added one more Customer Id in the local Excel and we will overwrite the existing Excel with this newly added Customer Id 8 by following the steps below.

  1. Select the Excel Data source that you want to overwrite, click More click-more and select the Overwrite Data option.


    overwrite-data-option


    The Overwrite Data dialog box is displayed.


    Overwrite Data dialog box


  2. Select the Excel file to overwrite the data and click the Overwrite button.


    click overwrite button


    A confirmation message is displayed. Click Dismiss on the message box.


    confirmation message


    The data is overwritten as shown below.


    data overwritten