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.Truncate
Truncate text to a specific length
Parse Number
Convert a string to a number
Divide
Divide two numbers
Multiply
Multiply two numbers
Subtract
Subtract two numbers
Sum
Add two numbers together
Percentage
Calculate percentage
Absolute
Get absolute value of a number
Format Currency
Format a number as currency
Case
Change text case (upper, lower, title)
Replace
Replace text in a string
Split
Split a string into an array
AES Decrypt
Decrypt AES encrypted data
Array Get
Get element from array by index
Format Date
Format a date value
Parse Date
Parse a date string
Difference Between Dates
Calculate difference between two dates
Add to Date
Add time to a date
Subtract to Date
Subtract time from a date
Get Date Occurence
Get specific occurrence in date
Aggregate Numbers
Aggregate array of numbers
Round
Round a number
Lookup
Lookup value in a dataset
Array Intersection
Find intersection of arrays
Array Unique Rank
Get unique values with ranking
Array Unique
Get unique values from array
Array Concat
Concatenate arrays
Format Currency (Locale)
Format currency with locale variable
Format Currency (Locale & Currency)
Format currency with locale and currency variables
Replace with Variable
Replace text using a variable
Template
Apply template transformation
Extract
Extract data using pattern
Create Hash
Create hash from value
Format Number
Format a number