Prefix transform function
Introduction
The prefix transform function is used to add characters to the start of a given string field. For example:
[
{"SKU": "RED001"},
{"SKU": "RED002"},
{"SKU": "BLUE001"},
{"SKU": "BLUE002"},
{"SKU": "GREEN001"},
{"SKU": "GREEN002"}
]...might become:
[
{"SKU": "AW25-RED001"},
{"SKU": "AW25-RED002"},
{"SKU": "AW25-BLUE001"},
{"SKU": "AW25-BLUE002"},
{"SKU": "AW25-GREEN001"},
{"SKU": "AW25-GREEN002"}
]Adding a prefix transform
Edit map shape settings
In your process flow, access settings for your map shape. For example:
Access transforms for the required mapping
Locate the mapping rule that you want to update (or add a new mapping rule), then click the transform button. For example:
Add a new transform
Click the add transform button. For example:
Select the prefix transform function
Click in the name field to access a list of all available transform functions, then select prefix from the string category. For example:
Enter your required prefix
In the prefix field, enter the characters that you want to append to the start of any source values for the source field. For example:
You can enter static text and/or flow/meta variables.
Confirm the source field to be transformed
Click the add field button:
...then click in source fields and select the source field to be used for this transform:
Confirm transform settings
Accept your changes (twice), then save the transform.
Using variables in prefix transform values
You can include flow or meta variables when defining prefix values. Some examples are shown below.
N/A
season : AW25
season : AW25
month : JUNE
month : JUNE
Last updated
Was this helpful?