Details on Data Function – Transformation

This dialog is used to select which function in the library to use as a transformation.

Note: Only those data functions that use a single data table as input (and no other inputs) and a single data table as output will be available for selection when using data functions as transformations.

To add a data function 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 Data function from the drop-down list and click Insert.

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

To add a data function 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 Data function from the drop-down list and click Insert.

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

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 Data function from the drop-down list and click Insert.

Click to select a keyword in the Keywords list that matches the type of data function you are looking for. You can further limit the number of data functions shown by typing some text in the search field. This limits the data functions visible to the ones matching the current search expression. For more information about valid search expressions, see Searching in TIBCO Spotfire.