Details on Replace Value

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 data canvas. 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 data table:

1. On the authoring bar, click Files and data .

2. In the Files and data flyout, locate the data of interest by searching for a suitable keyword or by browsing the different categories.

Tip: You can also apply transformations when you replace a data table and when you add columns or rows to an already existing data table.

3. In the Add data to analysis summary, click on the new data to expand the settings section, and click Transform data.

4. In the Transform data dialog, select Replace Value from the drop-down list and click Insert.

5. Click OK to close all dialogs and to add the data.

To add a Replace Value transformation to data that is already loaded into Spotfire:

1. Select Data > Transform data....

2. In the Data table drop-down list, select the data table you want to add the transformation to.

3. Select Replace Value from the drop-down list and click Add....

To add transformations to a specific node in the source view:

1. In the Data canvas, click on the node where you want to add a transformation.

Response: Details about the selected node are shown in the lower left part of the source view.

2. In the list of steps for the selected node, click on the plus sign where you want to add a new transformation (or transformation group).

3. In the Transform data dialog, select Replace Value from the drop-down list and click Insert.

4. Click OK.