Append

Modified on Fri, 24 Mar, 2023 at 3:04 PM

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:

AB
13
24
Dateset 1
AB
57
68
Dataset 2

The resulting dataset after running Append would look like this:

A
B
13
24
57
68

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

A
BDataset Name
13Dataset 1
24Dataset 1
57Dataset 2
68Dataset 2

Not all columns are shared in common

Consider the two datasets which have two common columns each:

ABC
135
246
Dateset 1
ABD
10
12
14
11
13
15
Dataset 2

The resulting dataset after running append would be this:

ABCD
135-
246-
1012-14
1113-15

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).

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article