append

Overview

The append statement is used to append one DSET to the end of another.

Syntax

appendsource_dset.idtodestination_dset.id

Details

If the source DSET has any column names not present in the destination DSET then additional columns are automatically created in the destination DSET. These additional columns will contain blank values by default.

If one or more column names are present in both DSETs then the columns copied from the source DSET may be re-ordered into the same order as that used by the destination DSET.

At the end of the operation, the destination DSET will contain all the data from both DSETs, and the source DSET is unchanged.

Both DSETs must exist and both should have data. To verify a DSET existents or to check whether a DSET is empty, use one of the following functions:

Additionally, it is not possible to append a DSET to itself.

Example

Given the following DSETs:

DSET ID: example.data

VMSize,RAM,CPU
small,2,2
medium,4,2
large,8,4
huge,16,8

DSET ID: example2.data

VMSize,storage
small,50
medium,100
large,500
huge,1000

The statement append example2.data to example.data will result in the following destination DSET (example.data):

VMSize,RAM,CPU,storage
small,2,2,
medium,4,2,
large,8,4,
huge,16,8,
small,,,50
medium,,,100
large,,,500
huge,,,1000