Available Transformations
Reelevant provides a comprehensive set of transformations to manipulate and format data. Transformations can be chained together to create complex data processing pipelines.Strings
Truncate
Truncate text to a specific length
Case
Change text case (upper, lower, capitalize)
Replace
Replace text in a string
Replace with Variable
Replace text using a variable value
Split
Split a string into an array
Extract
Extract data using a regex pattern
Template
Apply template transformation using sprintf format
Length
Get the length of a string
Pad
Pad a string to a target length
Create Hash
Create hash from value
AES Decrypt
Decrypt AES encrypted data
Numbers
Parse Number
Convert a string to a number
Format Number
Format a number with locale-aware formatting
Format Currency
Format a number as currency
Format Currency (Locale Variable)
Format currency with locale from a variable
Format Currency (Locale & Currency Variables)
Format currency with locale and currency from variables
Percentage
Format a value as a percentage
Absolute
Get absolute value of a number
Round
Round a number
Math
Divide
Divide two numbers
Multiply
Multiply two numbers
Subtract
Subtract two numbers
Sum
Add two numbers together
Aggregate Numbers
Aggregate array of numbers (sum, average, median)
Dates
Format Date
Format a date value
Format Date (Locale Variable)
Format a date with locale from a variable
Parse Date
Parse a date string into an ISO date
Difference Between Dates
Calculate difference between two dates
Add to Date
Add time to a date
Subtract from Date
Subtract time from a date
Get Date Occurrence
Get next or nearest yearly occurrence of a date
Arrays
Array Get
Get element from array by index
Array Get (Variable Index)
Get element from array using a variable index
Array Intersection
Find common elements between two arrays
Array Unique Rank
Get unique values sorted by frequency
Array Unique
Get unique values from array
Array Concat
Concatenate two arrays
Records
Lookup
Lookup a property value from a record