Transformations Reference

The field transformation types you can apply while data is transferred.

Last updated:

A transformation changes a field's value as data moves from the source environment to the target. Use transformations to anonymise personal data or to fill a test environment with realistic but harmless values.

Transformation Types

Each field of an entity has one transformation. The default is Pass-through, which copies the value unchanged. These are the others:

TypeWhat it does
ScrambleGenerates replacement values from patterns of the source data (word, separator and length models).
Static ValueReplaces every value in the field with one constant you specify.
AnonymizeGenerates type-aware anonymised tokens.
HideKeeps the field but sets every value to an empty string.
RegexpGenerates random values that match a pattern you configure.
IgnoreRemoves the field from the transfer entirely.

Which fields each type applies to

TypeField types
ScrambleString, Text
Static ValueString, Integer, Boolean, Decimal
AnonymizeString, Email
HideString, Text
RegexpString, Text
IgnoreAny field

Static Value and Regexp need a setting from you: the value to write, or the pattern to match.


Applying Transformations

You choose transformations in the Fields step of an action in the pipeline builder:

  1. Add an action and work through its steps until the Fields step. See Creating a Pipeline.
  2. Pick an entity. Its fields are listed with their key marker, name, type and current transformation.
  3. Open the transformation dropdown next to a field and choose a type. The dropdown describes each type.
  4. Enter the value or pattern if the type needs one.
  5. Repeat for each field you want to change. Fields you leave on Pass-through are copied as they are.

You can also select Skip Transformations to continue with every field unchanged.

Use Preview Results in the same step to see sample records, and the sample size beside it to choose how many.