Join node
Find & Replace
Look up an input field against a mapping table to replace found text or append matched fields.
What it does
A table-driven lookup: for every row of the Input it searches a chosen text field against a Lookup table's find values and, on the first match, either replaces the found text or appends the matching lookup row's fields. The Lookup supplies the values to find and their replacements (or the fields to attach), so you drive the whole mapping from a table instead of a formula per value.
Inputs and outputs
| Inputs | Input, Lookup. |
| Outputs | One. |
When to use it
- Normalize codes to names from a mapping table (country_code → country_name)
- Standardize or redact text using a list of terms and replacements
- Enrich records by attaching lookup attributes onto matched rows
Examples
Whole-field code lookup
Match: Entire field · Input: US · Lookup: US → United States
The field US becomes United States.
Fix a prefix
Match: Beginning of field · company_start_inc → ACME_inc
Only the matched prefix is replaced; the rest is kept.
Attach fields
On a match: Append · attach region, manager from the lookup
Unmatched rows get nulls in the appended columns.
Tips
- Two inputs: the Input (the data you search) and the Lookup (the find/replace mapping). Wire the right stream to each port.
- Match modes: Beginning replaces the prefix, Any Part replaces a substring, Entire replaces the whole field. Turn on Case insensitive or Match whole word only as needed.
- Any Part + Replace every occurrence applies all find values, replacing every hit; otherwise only the first match per row is used.
- The searched field must be text; appended columns keep their original type, and a name clash gets a suffix (default _lookup).