Replace value
The Replace Value transformation is used to edit a previously added transformation from the data canvas. It can also be used if you must add a replace value transformation to an earlier stage in the data table history (not to the final data table).
The most common way to replace a value is by double-clicking on the value in a table visualization and changing to a new value. See Replacing a value for more information. This dialog is used to edit such an added transformation.
See Transforming data for information about how to add a transformation to an analysis.
| Option | Description |
|---|---|
| In column | Select the column in which a value should
be replaced.
For example, if you have noticed that there is a misspelled value in the column 'Month', you select that column here. |
| Previous value | Type the value that you want to replace.
For example, if 'April' has been misspelled to 'Aprill', you type the misspelled value here (Aprill). |
| Value after formatting | [Only applicable for values of a data type
that can be formatted in different ways. For example, a Date, or a Real value.]
Shows the way the value is displayed in the analysis using the current formatting. |
| Replace value with | Type the new value instead of the previous
value.
For example, if 'April' has been misspelled to 'Aprill', you type the correctly spelled value here (April). |
| Value after formatting | [Only applicable for values of a data type
that can be formatted in different ways. For example, a Date, or a Real value.]
Shows the way the value is displayed in the analysis using the current formatting. |