Bulk Replace

Replace multiple values at once using groups

What It Does

Bulk Replace lets you map multiple values to group names at once. For example, map 'US', 'USA', 'United States' all to 'US'. Useful for standardizing categories.

How to Use It

Opening the Panel

Click the + button in the toolbar or press the operation picker, then search for "Bulk Replace". It's in the Transform group.

Configuration

Field	Type	Required	Description
`Column`	Column select	Yes	The column to remap
`Groups`	Group editor	Yes	Group name and the values that map to it

SQL Generated

SELECT *, CASE WHEN country IN ('US', 'USA') THEN 'United States' WHEN country IN ('UK', 'GB') THEN 'United Kingdom' ELSE country END AS country FROM data

Try this operation →

Notes

Null values are handled gracefully - operations skip or preserve nulls where appropriate.
You can edit any pipeline step by clicking on its card to re-open the panel with the same settings.
The SQL preview shows exactly what will execute - inspect it before applying.

Related Operations

Update Values - Update column values with expression
Find & Replace - Search and replace values in a column
Text Transform - Transform text: uppercase, lowercase, trim