Search…
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
1
VMSize,RAM,CPU
2
small,2,2
3
medium,4,2
4
large,8,4
5
huge,16,8
Copied!
DSET ID: example2.data
1
VMSize,storage
2
small,50
3
medium,100
4
large,500
5
huge,1000
Copied!
The statement append example2.data to example.data will result in the following destination DSET (example.data):
1
VMSize,RAM,CPU,storage
2
small,2,2,
3
medium,4,2,
4
large,8,4,
5
huge,16,8,
6
small,,,50
7
medium,,,100
8
large,,,500
9
huge,,,1000
Copied!
Last modified 2yr ago
Export as PDF
Copy link