The best 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 when you edit a previously added transformation from the Source view. However, 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).
To add a Replace Value transformation when adding a new data table:
Select File > Add Data Tables... and add the data of interest.
Click Show transformations.
Select Replace Value from the drop-down list and click Add....
Tip: The Show transformations-section is also available when replacing data tables and when adding columns or rows to a data table.
To add a Replace Value transformation to data that is already loaded into Spotfire:
The easiest way to perform the transformation is by double-clicking on the value in a table visualization and changing to a new value. See Replacing a Value for more information. However, it is also possible to insert a Replace Value transformation the same way as for other transformations, using the Insert menu.
Select Insert > Transformations....
In the Data table drop-down list, select the data table you want to add the transformation to.
Select Replace Value from the drop-down list and click Add....
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. |
See also: