Append data using Union operation

The union operation creates a single dataset by adding the contents of one or more datasets to another, and aggregates the column headers from the datasets to create the schema for the new dataset.

If one of the appended datasets doesn't have a column header from other datasets, the resulting dataset shows empty values in the respective column, as shown in the previous image in columns C and D.

Union multiple datasets

You can easily find the Union operation in the toolbar.

In this example, you want to combine orders data from 2014 to 2018. Therefore, you can select the orders data for 2014 and append other datasets to it.

Click Union:

Choose other datasets, click "OK":

Then, you will see the configuration panel as follows:

Click "+ADD", you can append more datasets.

Here you can see columns information for all datasets and control which columns are retained as a result.

In the above figure, "2018 Orders" does not have Row ID, so the value of this column will be empty after union operation.

Click "Save", you will get your expected result.