Preparation node
Formula Multi-Field
Apply one expression across several fields at once.
What it does
Applies ONE expression across a whole set of columns at once, using [_current] to stand for whichever column is being processed. It saves writing the same formula fifteen times in Formula. You can change the columns in place, or leave them alone and write the results into new columns with a prefix or suffix.
Inputs and outputs
| Inputs | One. |
| Outputs | One. |
When to use it
- Trim or upper-case many text columns in one go
- Round, scale or convert several numeric columns together
- Apply the same fix across a group of fields without listing each one
Examples
Clean many text fields
trim(upper([_current]))
[_current] becomes each selected column in turn.
Scale numbers
[_current] * 1.1
Applied to every numeric column you selected.
Into new columns
coalesce([_current], 0) → prefix: clean_
Leaves the originals alone and adds clean_<column> beside each.
Just a few columns
Turn off “All columns”, pick email + phone
The default is EVERY column, which is rarely what you want for a text function.
Tips
- By default this targets EVERY column. Turn “All columns” off and pick the ones you mean: an expression that only makes sense for text will produce nulls everywhere else.
- [_current] stands in for each selected column; everything else is the same expression language as Formula.
- Give a prefix or a suffix when writing to new columns, or the new name collides with the source.
- A selected column that isn't in the input is ignored rather than failing the run, so a stale pick left over from an older source is harmless.
- Check the result in the Data tab after a Test run. One expression across many columns is exactly where a surprise hides.