Functions are the building blocks of data transformation in WeTransform. They let you manipulate, clean, convert, and enrich your data — column by column, row by row.
There are two ways to apply a function: let the AI generate the rule for you, or configure it manually using the visual editor. Both lead to the same result.
🤖 The fastest way — describe it in plain language
Open the Rules editor and click "New rule". Instead of configuring the rule manually, click "WeTransform AI" at the bottom of the panel.
Type what you want to do in plain language — for example:
"Truncate the item name to 100 characters"
"Increase the price by 10%"
"The amount is in euros, convert it to dollars"
"Remove all special characters from the description column"
"Concatenate brand name and product name, separated by a dash"
WeTransform generates the rule instantly and shows you a preview of exactly what it will do. Click "Accept" to add it to your rules, or refine your prompt if the result isn't quite right.
🤖 The AI handles complexity. You don't need to know which function to use or how to configure it. Just describe the outcome you want — WeTransform picks the right function and fills in the parameters. The generated rule is always editable afterwards.
⚙️ The manual way — configure the rule yourself
If you prefer full control, you can build the rule manually. In the IF section, define a condition (or leave it empty to apply the rule to all rows). In the THEN section, choose a function from the dropdown.
Functions are organized into categories. Each function has clearly labeled fields — you fill them in and WeTransform handles the rest.
🔀 Condition operators (the IF part)
Conditions let you target specific rows. The operator dropdown is organized by category:
🔤 Text manipulation — starting with, contained in, containing, ending with, =, empty, not empty, upper/lower case, length checks, wildcard pattern
📅 Dates manipulation — before, after, between dates
🔢 Numbers manipulation — greater than, less than, between, equal to
🔗 Dependencies between columns — is filled if another column is filled, etc.
📋 Data types — is a valid email, is a valid URL, is a number, etc.
📁 Data formats — matches a specific format pattern
🔍 Lookup — value is in a list, value exists in another column
⚡ Action functions (the THEN part)
Action functions define what happens to the data. They're also organized by category:
🔤 Text manipulation — replace, split, get left/right of text, get text length, change to lower case, remove text, remove special chars, remove HTML tags, remove line breaks, extract text between strings, create UUID, newline, repeat prefix
🔢 Numbers manipulation — add, subtract, multiply, divide, round, format decimals, absolute value
📅 Dates manipulation — convert date format, add/subtract days, get current date
📋 Aggregations — sum, count, average, min, max across groups
📁 Data formats — format as currency, percentage, phone number
🤖 Power functions — call an external API to validate or enrich data
🌟 Other actions — filter out, insert line, duplicate/deduplicate, insert/remove tags, fill the gaps with AI, generate content with AI
💡 Not sure which function to use? Use the AI mode — describe what you want in plain language and let WeTransform pick the right function. You can always switch to manual mode afterwards to fine-tune the parameters.
📚 Need examples?
Check the FAQ — Examples of rules and functions for ready-to-use recipes covering the most common scenarios: price calculations, date conversions, text cleaning, EAN prefixing, key-value extraction, and more.
👉 What to do next