You can use
Replace value with the All occurrences in column-option to replace all instances of a value directly from a table visualization, or from the Details-on-Demand.
The procedure for replacing a single occurrence of a value in a column is quite similar, but that requires that a key column has been specified for the data table. See
Replacing a specific value in a column for more information.
You can also right-click and select
Replace value from the pop-up menu.
Type a new value in the popover.
Make sure that
All occurrences in column is selected.
All instances of the value are replaced in the column and any visualizations using the data are updated.
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
Using a different version of Spotfire?This help describes the web client version of Spotfire on TIBCO Cloud™. If you're looking for documentation for the installed client or other versions of Spotfire, visit the TIBCO Documentation Portal.