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 data canvas.
On the authoring bar, click
Make sure the data table of interest is selected in the upper-left drop-down list.
In the data canvas, 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 data canvas.