A data table can be based on data from one or more data sources. Use this dialog to replace one of the data sources, while keeping the data table intact. When you replace the data source rather than the data table, you keep all applicable transformations, operations and calculations done after the data was first added.
Option |
Description |
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. At least one of the views in the data connection must allow 'Import data' as the load method. |
Data Source in Library... |
Allows you to choose data 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. Note: You cannot change the load method when replacing the data source. Use the Replace data table option if this is needed. 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 not applicable in this context. You cannot change the load method when replacing the data source. Use the Replace data table option if this is needed.] |
Import
data |
[The option to change the load method is not applicable in this context.] |
Keep
data external |
[The option to change the load method is not applicable in this context.] |
Load
on demand |
[Only applicable when working with data from information links or connections to external systems.] |
Settings... |
Opens the On-Demand Settings dialog where you specify what will control the loading of data. |
[Existing transformations will be kept.] |
If the previous data source was added together with one or more transformations, you will be informed about this here. All existing transformations are kept, but you may need to update transformations after replacing the data source. See Existing Transformations and Editing Transformations for more information. |