transpose

Swap the positions of rows and columns in a data extract.

Introduction

Use the transpose enrichment to swap the positions of rows and columns in a data extract. The values in the rows of the first column are used to name the transposed columns.

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 (*).

Row limit*

Enter the number of rows to be transposed. All rows after this limit are removed from the data extract.

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

Row limit*

3

Data table before enrichment

Ad Group	Region	Clicks
media	UK	3493
ecommerce	UK	8891
media|social	France	2782
social	Germany	7397
outreach	USA	6397

Data table after enrichment

Ad Group	media	ecommerce	media|social
Region	UK	UK	France
Clicks	3493	8891	2782