Append

Description

This step combines two datasets which share common columns into a single dataset by stacking them upon each other.

Application

Often in engineering, data is not always in one big table but distributed over several tables. That is, you start with different tables that you might want to append together to obtain one big table that you can use for cleaning, visualisation, comparison, etc.

How to use

• Select the Datasets that should be combined into a single dataset.
• Enable Add dataset name column if you want to identify the source dataset in the new combined dataset.
• Enable Save output under different name if you want to save the resulting dataset under a new name. If this option is disabled the new combined dataset will be saved under the name of the first dataset in the list.
• Click Apply to run the append operation.

Examples

Both datasets share all columns

Consider the two datasets which have two common columns each:

The resulting dataset after running Append would look like this:

If the option Add dataset name column was enabled the resulting dataset would look like this:

Not all columns are shared in common

Consider the two datasets which have two common columns each:

The resulting dataset after running append would be this:

No data is lost by the append operation. All columns will be added to the final dataset but columns which are not shared by all involved datasets are going to produce empty cells (i.e. missing data).