Transformations Reference
The field transformation types you can apply while data is transferred.
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:
| Type | What it does |
|---|---|
| Scramble | Generates replacement values from patterns of the source data (word, separator and length models). |
| Static Value | Replaces every value in the field with one constant you specify. |
| Anonymize | Generates type-aware anonymised tokens. |
| Hide | Keeps the field but sets every value to an empty string. |
| Regexp | Generates random values that match a pattern you configure. |
| Ignore | Removes the field from the transfer entirely. |
Which fields each type applies to
| Type | Field types |
|---|---|
| Scramble | String, Text |
| Static Value | String, Integer, Boolean, Decimal |
| Anonymize | String, Email |
| Hide | String, Text |
| Regexp | String, Text |
| Ignore | Any 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:
- Add an action and work through its steps until the Fields step. See Creating a Pipeline.
- Pick an entity. Its fields are listed with their key marker, name, type and current transformation.
- Open the transformation dropdown next to a field and choose a type. The dropdown describes each type.
- Enter the value or pattern if the type needs one.
- 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.