Use the Replace Data Table option to switch to completely different data, or to switch the type of data table from an in-db data table to an imported table, or vice versa.
Note: If you want to keep transformations, added data and other intermediate operations, you should consider replacing the data source instead of replacing the entire data table.
To reach the Replace Data Table dialog:
Select File > Replace Data Table....
Option |
Description |
Select
data table to replace |
Specifies which data table to replace. |
Select
a new data source |
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 choose data from a file. |
Information
Link... |
Allows you to choose data from an information link. |
Data
from Library... |
Allows you to choose data from an SBDF file located in the library. |
Data Connection in Library... |
Allows you to choose data from a saved connection in the library. If the selected connection contains multiple views you must specify which view to use in the Select Data Table dialog. |
Data Source in Library... |
Allows you to add a data table based on a saved data source in the library. See Views in Connection or, for cube data sources, Data Selection in Connection for more information about selecting what data to include in a connection to a data source. |
Clipboard |
Allows you to choose data from the clipboard. |
Data
Function... |
Allows you to choose data from a data function. |
Connection
To |
Use one of the data connection options to choose data 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, all views in the connection will be available within the analysis until the connection or a view is removed using Edit > Data Connection Properties, regardless of whether the view is added as a data table or not. Therefore, you should use the option From Current Analysis (see below) to add more views from an already used connection rather than adding another connection to the same source. See What is a Data Connection? for more information. Note: If a connector is listed in gray text under Unavailable Connectors, it means you must install a data source driver on your computer to use that connector. See Getting Started with Connectors for more information on installing data source drivers. 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 choose data from the current analysis. For example, you may want to pivot or otherwise transform the data in an already existing data table. This option is also the preferred option if you decide to choose 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 choose 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 from connections to external systems.] |
Import
data |
Select this option to bring the selected data into Spotfire's internal data engine (in-memory analysis). |
Keep
data external |
Select this option if you want the selected data 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. |
See also: