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.

Note: The toolbar at the top of the expanded data panel always applies to the final data table, and not to the selected node in the graphical view. This means that a replace operation will replace everything done with the data table up until the final node. Similarly, "delete" will remove the entire data table.

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.

Expanded Data panel, source view.

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:

Here, you can also reload linked data, as described in Reloading data.
Note: Some nodes do not have access to the original source. In that case, the only option available will be Stored data. For example, this is the case when you have uploaded a file from your local computer to Spotfire Business Author.
When more rows have been added to the original data table, the data to add is shown as a separate node (4), and the original data plus the added rows is shown in the Added rows node (5).

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).