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 Specific Value transformation when adding a new data table:
Select File > Add Data Tables... and add the data of interest.
Click Show transformations.
Select Replace Specific 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 Specific 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 Specific 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 Specific 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. |
Identify
row by |
Lists the currently defined key columns to use to uniquely identify the row. If no key columns have been defined, click the arrow to expand the section and define key columns. |
Key
column |
Lists the name of all key columns that have been defined so far. |
Value |
Shows the value of the key column on which to replace the specific value. For example, if you have an ID column containing different ID numbers, and you want to replace the value for the ID 'TM20176', then you type this ID value here. |
Click on the plus sign to add another column as a key column, which can be used to uniquely identify the row value that should be replaced. |
|
Warn
if more than one value is replaced |
Select the check box to get an error message in the Source view if the specified key columns do not uniquely identify the row and more than one value is replaced by this transformation. For example, if you have specified unique keys and a reload of the data has modified the available rows, so that the keys are no longer unique, then you may want to be informed about this. Clear the check box if you do not care about how many values are replaced, or, if you want to replace all values in a column matching a certain value in the key column. For example, you can use this transformation to replace the last name on all rows matching a certain Social Security Number. However, if you want to replace all instances of a value in a column, you might want to use the more general Replace value transformation instead. |