Append
In DataPrep, you can append one dataset with another and create a new dataset using the Append transform. Here's a quick video on how to use the Append transform.
To append datasets
1. Click the
Transform
menu, click
Combine
, then select
Append
.
2. In the
Append dataset
dialog, you can choose the dataset that you want to append to the current dataset.
3. Enter a name for the new dataset in the
New dataset name
box in the transform panel.
A new dataset will be created with the result of the Append transform.
4. DataPrep compares the column names of the two datasets and shows the unmatched columns so can choose to include or exclude them. For the matched ones, incoming data is added directly below the columns that have matched.
5. Click the
Preview
button and DataPrep will show a live preview of the append transform.
6. Click
Append
to apply the transform.
Once you've successfully combined the two datasets by appending the rows, click
Open the combined dataset.
7. If you want to edit the append configuration, you can open the Data source configuration from the Ruleset pane from the newly created dataset and edit the configuration.