This section explains how to use the
Append Data option in Bold BI Enterprise.
Append Data Source allows users to append the selected files to an existing data source table. Currently, this feature is available for file types such as Excel, JSON, CSV, and XML.
To append data in an existing data source, click on the
append data icon. The dialog will open, as seen in the following.
Choose the table name from the selected tables dropdown in which the data should be appended.
Append Data Source allows users to append both single and multiple files.
Browse File to select the files you want to append, as shown in the following image.
Once the selected files are uploaded, the schema comparison will be done, and the validation status will be updated as follows.
Single file upload
Multiple files upload
If the schema validation has failed, delete the file by clicking the
Delete icon and browse with a valid file to append again, as shown in the following image.
Once you see the success message
Ready to append, the Append and Save As options will be enabled.
Save As option allows you to create a new data source with the selected files along with the existing data source data.
Save As button and provide the new data source name and click the
Append button will move the selected files data to the existing data source table.
After clicking the
Save As or
Append button, the append process will be initiated, and the append status will be shown as follows.
The Waiting pop-up indicates that the append process has started, as shown in the following image.
The Success pop-up indicates that the append process has been completed successfully, as shown in the following image.
The Failure pop-up indicates that the append process has failed, as shown in the following image.
Close icon to close the notification pop-up after the process completion, as shown in the following image.