Removing a data source from a data table
If your data table was built on data from more than one data source (by addition of columns or rows), you can remove data sources from the data table as they become obsolete. This is done in the source view of the expanded data panel.
- In the Data panel, click the Expand data panel for tools and details button, .
If you cannot see the source view button, you may need to click the Go to data table view link first.
In the Source view, hover with the mouse pointer over the data source node or the add rows/columns node that you want to remove.
An icon with a trash can is shown at the upper left corner of the node.
Hovering with the mouse pointer over the icon before clicking it will show you an animation of what will be removed from the data table; for example, a data source and the add rows operation it belonged to.
A confirmation message is shown.
- Click OK.
If a data source with transformations on the source node itself is removed, then the transformations will be discarded. Transformations on an Added rows node or on an Added columns node will be transferred to the nearest remaining node. If desired, you can always remove any remaining transformations at a later stage, see Removing operations in the Source view.