Replacing all occurrences of a value in a column
You can use Replace value with the All occurrences in column-option to replace all instances of a value directly from a table visualization, from the Details-on-Demand, or from the column overview in the expanded Data in analysis flyout.
About this task
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.
Before you begin
Procedure
Results
The replacement 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 and any additional rows matching the rule will also be
replaced in the analysis. 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.