Details on Normalization

This dialog is used to transform a data table by normalizing the data in one or more of its columns.

Tip: You can replace a data table with a transformed version of itself.

To add a Normalization transformation when adding a data table:

On the authoring bar, click Files and data .
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.

In the Add data to analysis summary, click on the new data to expand the settings section, and click Transform data.
In the Transform data dialog, select Normalization from the drop-down list and click Insert.
Click OK to close all dialogs and to add the data.

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

Select Data > Transform data....
In the Data table drop-down list, select the data table you want to add the transformation to.
Select Normalization from the drop-down list and click Add....

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

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.

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).
In the Transform data dialog, select Normalization from the drop-down list and click Insert.
Click OK.

Option	Description
Result option
Add columns	Click this radio button to add new normalized columns to the resulting data table. The old columns will also be kept.
Replace selected columns	Click this radio button to replace the old columns with the new, normalized ones.
Available columns	Lists the columns available in the selected data source.
Add >	Moves the columns selected in the Available columns list to the Selected columns list.
< Remove	Removes the selected columns from the Selected columns list.
Remove All	Removes all columns form the Selected columns list.
Move Up	Moves the selected column in the Selected columns list up one step.
Move Down	Moves the selected column in the Selected columns list down one step.
Selected columns	Lists the columns that are selected to be normalized.
Method	Specifies the normalization method to use. See Normalizing Columns and the theory section for each method for further information about the various methods.
Baseline column	Specifies the baseline column to use (in some normalization methods only).
Percentage	Specifies the percentage value (P) to use when normalizing by percentile or by trimmed mean.
Description	Shows a brief description of the currently selected normalization method.
Column names setting	Specifies how the naming of the normalized columns should be handled. You can either add the word "Normalized:" to the column name of the original columns or use the expression (normalization equation) as a column name. If you have selected to replace columns you will also get a third option where you can keep the current column names.