Drop Row(s)

From PresenceWiki
Revision as of 08:37, 21 August 2015 by Rob (Talk | contribs)

(diff) ←Older revision | view current revision (diff) | Newer revision→ (diff)
Jump to: navigation, search

Drop Row(s)

This Node (selectively) deletes records from the current Data Table.

If no Rules are in place this Node will delete all the current records. You can restrict this to only delete records that match certain criteria by double-clicking on the Node in your Task and specifying which rules should apply:

Rules dialog.png


Let's imagine we need to create a sales report identifying under-performing regions. We want our report to include regions where the quarterly turnover has been less than the average for the entire company. Our initial data table (which we'll create with the Create Data Table node) contains the following:

Create data table for drop rows.png

We can then calculate the average turnover using the "Calculate Column Aggregate" node. Following this, a "Drop Rows" node removes any rows which match the condition:

Drop rows example.png

And here is the resulting Data Table, which only contains records where the turnover is below the average (£ 67,530.00}:

Drop rows result.png

Data Filter | Require Columns | Append Data Column | Multiple Column Appender

Drop Column | Drop Row(s) | Calculate Column Aggregate | Dataset Splitter | Merge Data

Create Data Table | Clear Data Table | Sort Data Table | Drop Duplicate Rows | Store Data Table | Retrieve Data Table

Task Elements > Data Table Nodes > Drop Row(s)