Choosing how to load the data
When you have selected your data and added it to the Files and data flyout, you will see a summary of all data tables that will be added or updated. The summary view allows you to modify data loading settings (when this is applicable), and you can also select to exclude a data source that you do not need.
In the summary view, you will see one box per new source, and, depending on whether the new sources will be added as new data tables or combined with other data, there will be a header for each new or updated data table.
In this example, data was added from a data connection, containing two views. Because these two sources were not that similar to each other, the first suggestion is to add them as two separate data tables.
- Click on the box for a certain source to expand the box and see the available settings.
If you have more than one data source in your analysis, you can select to add new data either as a new data table or as rows or columns appended to other data. Spotfire will always default to the recommended option. Change how to add the selected data using the drop-down list.
If you choose to add the new data as rows or columns, you must also select to which other data to append your data.
If desired, you can review or edit the settings for added rows or columns by clicking the settings button
See Editing column matching or other settings for added rows and Editing settings for added columns for details about what you can change.
For data from data connections, you have the option to change the load method for the added source data. Click the drop-down list showing
External to change the setting.
See Load methods for more information.
If a predefined data connection contains more views than you are currently interested in, you can select to exclude the view by clicking
Click the box again to include a view, if you excluded it by mistake. You can add a previously excluded view at a later stage by adding the view using the Data connections in current analysis option in the Files and data flyout, or by editing the data connection from the data canvas.
- If desired, you can change the name of a data table by clicking the icon with a pencil next to the data table name and typing a new name.
When you are satisfied, click
You can edit settings for your data source, or for added rows or columns, in the data canvas at a later stage. However, to change the load method from external to imported or vice versa, you must replace the entire data table.