reorder

Reorder the columns in a data extract.

Introduction

Use the reorder enrichment to reorder the columns in your data extract. Any columns names you do not include in the enrichment are kept in their original position.

Creating the enrichment

For more information on creating an enrichment, see Using custom scripts.

Configuring the enrichment

To configure the enrichment, fill in the following fields. Required fields are marked with an asterisk (*).

Fields*

Click Add and enter the name of the column to be reordered. The order in which you enter the column names are the order in which they are reordered.

Subtable

Enter the name for a subtable that you want to contain the enriched data. The enrichment is applied to the whole data extract, then the enriched data is output into the subtable you have named here.

This subtable is a temporary table, which means it 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.

Example

Enrichment configuration

Fields*

Ad Group

Clicks

Views

Data table before enrichment

Ad Group	Campaign	Clicks	Views
media	Brand	756	2771
ecommerce	Brand	351	1108
media	Dashboard	183	1080
media|social	Dashboard	51	239
media	Dashboard	117	781

Data table after enrichment

Ad Group	Clicks	Views	Campaign
media	756	2771	Brand
ecommerce	351	1108	Brand
media	183	1080	Dashboard
media|social	51	239	Dashboard
media	117	781	Dashboard