Details on Change Column Names

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

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

To add a Change Column Names 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 Change column names from the drop-down list and click Insert.
Click OK to close all dialogs and to add the data.

To add a Change Column Names 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 Change column names from the drop-down list and click Add....

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

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 Change column names from the drop-down list and click Insert.
Click OK.

Option	Description
Available columns	Shows all available columns. You can narrow down the list of available columns by typing a part of a name in the "Type to search" field. You can also enter an expression in the field, using the rules described on the Searching in Spotfire page. Press Ctrl or Shift to select multiple columns.
Add >	Adds the selected columns to the Columns to rename list.
< Remove	Removes the selected columns from the Columns to rename list.
Remove All	Removes all columns from the Columns to rename list.
Columns to rename	Lists the columns you have selected to rename and shows you the name ([%C]) that can be used to apply the same function on all columns in the Expression field.
Function	Select a function by clicking on it in the list and then click on the Insert button, or double-click on the function to send it to the Expression field.
Description	Shows a brief description of the selected function. For more detailed descriptions, see the Text functions page.
Insert >	Inserts the selected function in the Expression field.
Expression	This is the text field in which you build your expression on how to rename columns. You can insert functions from the lists or enter text as in any standard text editor. Many of the functions require you to type either the name of the column you want to rename or the common name given by the Columns to rename list.
New column names	Shows the renamed columns.