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