The source view of the expanded Data panel shows how data has been added to the data table, and whether any other modifications have been done to obtain the final data table. Each object in the upper part of the source view is called a node, and it represents either a data source or an operation where data from two sources have been combined. In the source view, you can click on different nodes to see what has been done with the data in that step. This can help you get an insight in how the final data table, used in the analysis, was created. You can also use the source view to change settings for different nodes, or to reload data from different sources.
In the Data panel, click Expand data panel for tools and details, . If no column was selected, 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 and more rows and columns have been added to the original data table from local data files.
1. Click on a node to view more information about that node in the fields below.
2. If the settings for the node can be changed, click on the settings icon under the node to edit the node. See Editing a data connection, Editing column matching or other settings for added rows and Editing settings for added columns for more information.
3. For some types of sources, you can change the Data loading settings by clicking on the button at the bottom of a node, and switching to a different setting:
5. The original data plus the added rows is shown in the Added rows node. Corresponding new nodes are shown for added columns.
6. You can add more rows or columns to a certain point in the data structure by clicking the plus sign between two nodes.
7. The field at the bottom left shows the list of step groups on the currently selected node, and, when applicable, provides an entry point for replacing a data source or for removing previously added operations. If there is an issue with an operation, you will be informed about this using icons and tooltips. If you want to add more rows or columns to a certain point in the structure, you can click the plus sign of interest and select the desired operation. Note that if you insert rows or columns between transformation groups in the list of step groups, any transformations below the insertion point will be moved to the new node in the data structure.
8. The field to the right shows details about the selected operation, or, if you click on the Data header, a preview of the data table at this current stage (when applicable).
9. The node to the far right represents the final data table, the way it is used in visualizations in Spotfire, after any data from additional sources or calculated columns have been added, or any other operations have been performed on the original data.
10. If you want to return to the Data table view for the final data table, click on the Data table view button.