Details on Insert Columns – Select Source

Option	Description
Add columns to data table	Specifies which data table to add columns to.
Add columns from	Specifies the source from which to add columns.
File	Allows you to add columns from a file.
Information Link	Allows you to add columns from an information link.
Data from Library...	Allows you to add columns from an SBDF file located in the library.
Database	Allows you to add columns from any supported database.
Clipboard	Allows you to add columns from the clipboard.
Data Function...	Allows you to add columns from a data function.
Connection To	Use one of the data connection options to add columns from an external data source. When adding columns from data connections the data must always 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 columns from a data table in the current analysis.
Other	Allows you to add columns 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.]
Import data table	[The option to change the load method is not applicable in this context.]
Keep data table external	[The option to change the load method is not applicable in this context.]
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 columns you want to add. For more information, see the Show transformations dialog.
Next >	Continues to the next step of the wizard where the matching columns are selected.
Finish	Automatically matches all columns with the same external ID or, of subordinate importance, the same name. The columns that were not used in the matching are also added to the data table. Note: If you have columns with identical names that do not contain the same identifiers, this option might result in that no data is added. In that case, it is probably better to use the Next > button (see above), and match on columns that contain correct identifiers.