Example: Source view
In the source view mode of the expanded Data panel, you can click on different nodes to see which operations have been performed on the original data to obtain the current data table. This can help you getting an insight in how the final data table, used in the analysis, has been created. You can also change the Data loading settings for different nodes or reload data.
In the
Data panel, click
Expand data panel for tools and details,
. If no column was selected, then you will see the
Data table view and can click
Source view directly. If a column was selected, first click
Go to data table view.
In this example, a data table has been loaded from Salesforce.com and more rows have been added to the original data table from a local data file.
The source view shows a visual representation of added data or operations. Click on a node (1) to view more information in the fields below. If the settings for the node can be changed, click on the settings icon under the node to edit the node (2). See Editing a data connection and Editing column matching or other settings for added rows for more information.
For some types of sources, you can change the Data loading settings by clicking on the button at the bottom of a node (3), and switching to a different setting:
The field at the bottom left shows the operations in the currently selected node (6). If there is an issue with an operation, you will be informed about this using icons and tooltips. This is also where you can remove previously added operations. The field to the right (7) shows details about the selected operation, or, if you click on the Data header, a preview of the data table at this current state (when applicable).
The node to the far right represents the final data table (8), the way it is used in visualizations in Spotfire, after any additional rows, calculated columns or other operations have been performed on the original data.
If you want to return to the Data table view for the final data table, click on the Data table view button (9).