Details on Replace Data Table

Option

Description

Select data table to replace

Specifies which data table to replace.

Select source to replace with

Specifies the source of the new data.

  Select

Opens a drop-down list where you can select the source to get a new data from.

At the top of the list you can enter a phrase to search for and limit the number of shown options in the list. The search is not context-sensitive.

Different types of sources are grouped under headers as described below.

     File...

Allows you to add a data table from a file.

     Information Link...

Allows you to add a data table from an information link.

     Data from Library...

Allows you to add a data table from an SBDF file located in the library.

     Clipboard

Allows you to add a data table from the clipboard.

     Data Function...

Allows you to add a data table from a data function.

     Connection To

Use one of the data connection options to add a data table from an external data source. It can be particularly useful when you are analyzing massive amounts of data and you want to keep the aggregation of data in the database (in-db) rather than bringing the data into Spotfire's internal data engine. However, a data table from a connection can also be imported.

When a data connection is added to the analysis, the data connection views will remain in the analysis until the connection is removed using Edit > Data Connection Properties. See What is a Data Connection? for more information.

Note that the available connection types depend on which licenses and drivers you have access to. See Connectors Overview for more information.

    From Current Analysis

Allows you to add a data table from the current analysis. For example, you may want to pivot or otherwise transform the data in an already existing data table, but you also want to keep the original data in the analysis.

This option is also the preferred option if you decide to add a data table based on a view from an already added data connection.  See What is a Data Connection? for more information.

     Other

Allows you to add data from other data sources that might be available to you. For example, you can add a data table from a database and bring the data into Spotfire's internal data engine (in-memory analysis).

Load method

[The option to change the load method is only applicable when working with data tables in connections to external systems.]

   Import data table

Select this option to bring the data in the selected data table into Spotfire's internal data engine (in-memory analysis).

   Keep data table external

Select this option if you want the data in the selected data table to remain in-database.

Load on demand

[Only applicable when working with data tables based on information links or data tables in connections to external systems.]

Settings...

Opens the On-Demand Settings dialog where you specify what will control the loading of data.

Show transformations

Expands the dialog and allows you to apply transformations on the data table you want to add. For more information, see the Show transformations dialog.