Appends data from another stream or subtable to the current stream. Identical columns will be concatenated (Example 1), whilst new columns are added by default (Example 2), behaving identically to an "outer join".
Streams | The complete name(s) of the Datastream(s) you wish to be appended. |
Subtables | The complete name(s) of the Subtable(s) you wish to be appended. |
Meltdown | Append extracts from current datastream. Can be combined with tags. |
All | If ticked, all extracts will be appended to the dataset. If unticked, only the most recent extract will be appended. |
Process extracts by |
Determine the order in which the system processes fetches. Choose between:
|
Include Tags | Only append streams containing the tag(s) specified here. |
Exclude Tags | Exclude all streams containing the tag(s) specified here. |
Errors | Specify the action to be taken if an error is encountered during the append process. Defaults to "strict". |
Subtable | Perform the transformation within a subtable, named as per this field. |
Example 1

Table 1
|
Table 2
|
New Unified Table
dim_A | dim_B | metric_1 |
AAA | DDD | 111 |
BBB | EEE | 222 |
CCC | FFF | 333 |
GGG | JJJ | 444 |
HHH | KKK | 555 |
III | LLL | 666 |
Example 2

Table 1
|
Table 2
|
New Unified Table
dim_A | dim_B | metric_1 | dim_C | dim_D | metric_2 |
AAA | DDD | 111 | |||
BBB | EEE | 222 | |||
CCC | FFF | 333 | |||
GGG | JJJ | 444 | |||
HHH | KKK | 555 | |||
III | LLL | 666 |
I Ain't Afraid of No Code!
[
[
"append",
{
"all": false,
"errors": "strict",
"include_tags": null,
"subtables": null,
"subtable": null,
"streams": [
"Table 2"
],
"exclude_tags": null,
"meltdown": false,
"process_extracts_by": "most_recently_scheduled",
"_comment": null
}
]
]
param boolean all: If set to true, all extracts will be appended.
param str errors: Ignore or raise errors.
param list include_tags: Append only streams with given tags. Without include_tags nor exclude_tags given, the most recent extract of each stream/subtable will be appended.
param list subtables: Data from which subtables should be appended.
param list subtable: Perform the transformation within the subtable that you specify.
param list streams: Data from which datastreams should be appended.
param list exclude_tags: Exclude all streams with given tags. Exclude has precedence over append.
param boolean meltdown: Append extracts from current datastream.
param str process_extracts_by: Determine the order in which the system processes fetches.
param str comment: A comment that will appear in the Transformation UI.
Comments
0 comments
Article is closed for comments.