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 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).

  1. Select File > Add Data Tables... and add the data of interest.

  2. Click Show transformations.

  3. 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.

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.

  1. Select Insert > Transformations....

  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....

data_replace_value_d.png

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:

Transforming Data