movefield

Move a column to a new position in the data extract.

This guide explains how to configure the movefield instruction. To learn about another instruction, go back to the Available custom script instructions overview.

Introduction

Use the movefield instruction to move a column to a new position in a data extract.

Creating a custom script transformation using the movefield instruction

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

  1. Create a custom script transformation.

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

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

Field name

Enter the name of the column to move.

Field Index

Specify where to move the column to in the data extract. To move the column to the first position, enter 0. To move the column to the last position, enter -1.