Instead of building transformation rules manually with conditions and functions, you can simply describe what you want in plain language — and WeTransform generates the rule for you.
📍 Where to write rules
The Rules editor is accessible at any point in your workflow — from the Match screen, from Finalize, or from your transformation settings. Click "Rules" to open it.
✏️ Writing a rule in plain language
In the Rules editor, click "New rule". In the THEN section, open the action type dropdown and select "Generate content with AI". You can then type your instruction directly — for example:
"If the price is negative, set it to 0"
"Concatenate the brand name and the product name, separated by a dash"
"If the category column contains 'AXE', replace it with 'Tools'"
"Convert the date from DD/MM/YYYY to YYYY-MM-DD"
"Round the price to 2 decimal places and use a dot as the separator"
🤖 The AI handles complexity. You can describe multi-condition rules, cross-column calculations, or format conversions in natural language — WeTransform will generate the exact rule logic behind the scenes. The generated rule is always editable if you want to fine-tune it.
⚙️ What rules can do
Rules are structured around a simple IF / THEN logic:
IF a condition is met (or no condition — always apply)
THEN do something to the data
The available action types cover a wide range of transformations, including:
🔤 Text manipulation — uppercase, lowercase, trim, replace, concatenate
🔢 Numbers manipulation — add, subtract, multiply, round, format decimals
📅 Dates manipulation — convert formats, add/subtract days
🗑️ Filter out — remove rows that match a condition
➕ Insert line — add a new row based on a condition
📋 Aggregations — group and summarize data
🏷️ Insert / remove tags — mark rows for later use in other rules
🤖 Generate content with AI — let the AI write or transform content
⚡ Power functions — call an external system to validate or enrich data
💡 Rules are reusable. Once created, a rule is saved in your transformation configuration. It applies automatically every time a new file runs through the same transformation — you never have to write it twice.
📚 Need inspiration?
Check out our FAQ — Examples of rules and functions for ready-to-use examples covering the most common transformation scenarios.
👉 What to do next