Transformations

Transformations modify extracted values after extraction. You can chain multiple transformations together.

Available Transformations

Transformation	Description
trim	Remove leading/trailing whitespace
prefix	Add text to the beginning
suffix	Add text to the end
replace	Find and replace text
regex	Extract using regular expression
cast	Convert to number (integer or float)
json_parse	Parse JSON string
json_path	Extract value from JSON using path
script	Custom JavaScript transformation

trim

Remove whitespace from the beginning and end of the value.

Transformation: trim

prefix / suffix

Add text to the beginning or end of the value.

Transformation: prefix
Value: "https://example.com"

Transformation: suffix
Value: "?ref=rtila"

replace

Find and replace text.

Parameter	Description
find	Text to find
replace_with	Replacement text
flags	Regex flags (e.g., g for global)

Transformation: replace
Find: "$"
Replace With: ""
Flags: g

regex

Extract a specific part of the value using a regular expression.

Parameter	Description
pattern	Regular expression pattern
group	Capture group number (0 = full match)
flags	Regex flags
default_value	Value if no match found

Transformation: regex
Pattern: \$(\d+\.\d{2})
Group: 1
Default Value: 0

cast

Convert the value to a number.

Parameter	Description
to	Target type: integer or float
default_value	Value if conversion fails

Transformation: cast
To: float
Default Value: 0

json_parse

Parse a JSON string into an object.

Parameter	Description
default_value	Value if parsing fails

json_path

Extract a value from a JSON object using a dot-notation path.

Parameter	Description
path	Dot-notation path (e.g., data.items[0].name)

Transformation: json_path
Path: data.results[0].price

script

Run custom JavaScript to transform the value. The current value is available as value.

Parameter	Description
code	JavaScript code. Must return the transformed value.
default_value	Value if the script fails

Transformation: script
Code: return value.toUpperCase().replace("USD", "").trim();
Default Value: ""

Chaining Transformations

Transformations are applied in order. You can chain them:

1. trim
2. replace: "$" → ""
3. cast: float

Adding Transformations

1. In the Visual Builder, select a dataset property.
2. Click Edit Transformations.
3. Choose a transformation type from the dropdown.
4. Click Add.
5. Configure the transformation parameters.
6. Drag to reorder transformations.
7. Click Save & Close.