Local File Append

When new rows are added to the original data file, or when you want to consolidate data from multiple data files into a single dataset, you can use the append data feature. The append data feature will validate the fields of the newly uploaded file, compare the fields of the existing data with the new data to prevent append errors. When the user confirms that there are no issues, clicking confirm will append the new data to the end of the current dataset.

During file preview, you can "Set Header": select a specific row as the header, which will be used as the standard when setting the data structure in the next step.

You can also perform operations such as Select Rows and Columns and Transpose Rows and Columns. The purpose of Select Rows and Columns is to select a specific range of the file as the Dataset for import. The purpose of Transpose Rows and Columns is to convert the rows of the file into columns for use.

• When appending an Excel file with multiple worksheets, you can choose which specific worksheet to append.
• When appending a CSV file, you can select the column delimiter and file encoding.
• When fields do not fully match, the append process will prompt that unmatched fields will be filled with NULL, and new fields will be added to the dataset.