Details on Exclude Columns

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

To add an Exclude Columns 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 Exclude columns from the drop-down list and click Insert.

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

To add an Exclude Columns 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 Exclude columns 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 Exclude columns from the drop-down list and click Insert.

4. Click OK.