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 under the hood

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 →

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