Replacing a specific value in a column

You can use Replace value with the This occurrence only-option to replace a specific value directly from a table visualization, from the Details-on-Demand, or from the column overview in the expanded Data in analysis flyout.

Before you begin

Imported data (not in-database data) must be loaded in the analysis and the analysis must be in Editing mode.

If you want to replace just a single occurrence of a value in a column, you must be able to identify the row, even if the data is reloaded. This is done by specifying key columns for the data table. Key columns can be specified by clicking Key columns in the data canvas toolbar. See also Specifying key columns for a data table.

About this task

See also Replacing all occurrences of a value in a column.

Note: These steps are used to replace a few values in a column only, not to change the formatting of a column or to replace an entire data table. If you want to combine several different categories into one, you might want to use Group from marked categories instead.

Procedure

In a table visualization, in the Details-on-Demand, or in the expanded data in analysis flyout, double-click on the value you want to replace.
You can also right-click and select Replace value from the pop-up menu.
Type a new value in the popover.
Make sure that This occurrence only is selected.
Click Apply.

Results

The value is replaced and any visualizations using the data are updated.

The replaced value is added as a transformation on top of your data. The original data in your data source is not affected by this change. This means that if the underlying data is reloaded, the transformation will be reapplied after the reload. If a previous key column identification is broken by the reload, so more than one value is affected by the transformation, you will be informed about this in the data canvas. Also, if the underlying value is changed in the source data, so that the transformation is no longer applicable, you will see an indication about this in the data canvas.

Tip: You can remove a previously added 'replace value'-operation from your data table. See Removing operations in the data canvas for more information.

Tip: You can use one of the procedures under Exporting data to save the cleansed data table for reuse in other analyses.