append

Add fields to the data extract from another datastream or subtable.

Introduction

Use the append instruction to add fields to the data extract from another datastream or subtable. Identical columns are concatenated. New columns are added by default, behaving identically to an outer join.

Creating a custom script transformation using the append instruction

To create and configure a custom script using the append instruction, follow these steps:

1. Create a custom script transformation.

2. In the Instructions step, select the append instruction.

3. To configure the custom script instruction, fill in the following fields. Required fields are marked with an asterisk (*).

Streams*

Specify the names of the datastreams from which to add data to the data extract.

Subtables

Specify the names of the subtables from which to add data to the data extract.

Meltdown

Select this checkbox to add data extracts from the current datastream.

All

Select this checkbox to add data from all data extracts. If you leave this checkbox deselected, only data from the most recent data extract is added.

Process extracts by

Specify the order in which data extracts are added. Select one of the following:

• Most recently scheduled - start adding data from the most recently scheduled fetch.

• Most recently created - start adding data from the most recently created fetch.

Include tags

Specify tags to only include datastreams with these tags.

Exclude tags

Specify tags to exclude datastreams with these tags.

Errors

To configure Adverity's behavior when an error occurs during the transformation process, select one of the following:

• (Default) Select strict to notify you about the error and stop the transformation process.

• Select ignore to ignore the error and continue the transformation process.

• Select raise to notify you about the error and continue the transformation process.

Subtable

Enter the name for a subtable that you want to use within this custom script.

A subtable is a temporary table that only exists for this custom script. You can apply additional instructions within the same custom script to the subtable. However, the subtable cannot be used in any other custom scripts.

If a subtable does not exist for the current custom script, the transformation is applied to the data extract, and the enriched data is output into the subtable. If the subtable already exists for the custom script, the subtable is used as the input for the transformation and optionally as the output.

Example

Transformation configuration

Streams

Table 2

Data tables before transformation

Table 1 (the table to which the transformation is applied)

Campaign	Ad Group	Clicks
Brand	media	7
Brand	ecommerce	3

Table 2

Campaign	Ad Group	Clicks
Dashboard	media	18
Dashboard	media|social	5
Dashboard	media	11

Data tables after transformation

Table 1 (the table to which the transformation is applied)

Campaign	Ad Group	Clicks
Brand	media	7
Brand	ecommerce	3
Dashboard	media	18
Dashboard	media|social	5
Dashboard	media	11

Table 2

Campaign	Ad Group	Clicks
Dashboard	media	18
Dashboard	media|social	5
Dashboard	media	11