Preparation node
Dynamic Rename
Rename every matching column at once. Add or strip a prefix, replace text, or fix the capitalisation.
What it does
Renames columns by a rule instead of one grid row at a time. Add or strip a prefix, replace text, fix the capitalisation, or build the name with an expression, applied to every column or only the ones a rule picks out.
Inputs and outputs
| Inputs | One. |
| Outputs | One. |
When to use it
- Clean spreadsheet headers before a database load
- Prefix one side of a join so the two do not collide
- Strip a vendor’s prefix off every column at once
Examples
Database-safe headers
Change capitalisation → snake_case
“Customer Name (Legal)” becomes customer_name_legal. The single most useful setting here.
Prefix one side of a join
Add a prefix → src_
src_id, src_name, src_amount: no collisions downstream.
Only the numbers
Add a suffix _n · Which columns: Type: Number
Everything else keeps its name.
Strip a trailing tag
Find and replace · regex \s*\(.*\)$ → (blank)
Removes a parenthesised suffix from every header.
Tips
- snake_case lowercases, turns spaces and punctuation into an underscore and splits CamelCase (OrderDate becomes order_date). A name starting with a digit is left alone; rename that one by hand in Manage Columns.
- If two columns would end up with the same name, the node is refused and both are named, in the builder, before anything runs.
- Removing a prefix or suffix that is not there leaves the name alone rather than failing.
- In Find and replace with regex on, $1 in the replacement is the first capture group.
- The preview shows old → new for every column, and it is the engine’s answer rather than a guess.
- A freshly dropped Dynamic Rename is flagged in the builder until you type the text its rule needs, such as the prefix.