Difference between revisions of "Drop Row(s)"
(→Drop Row(s)) |
(→Example) |
||
Line 17: | Line 17: | ||
http://www.international-presence.com/wikidocs/images/drop_rows_example.png | http://www.international-presence.com/wikidocs/images/drop_rows_example.png | ||
− | And here is the resulting Data Table, which only contains records where the turnover is below the average (& | + | And here is the resulting Data Table, which only contains records where the turnover is below the average (£ 67,530.00}: |
http://www.international-presence.com/wikidocs/images/drop_rows_result.png | http://www.international-presence.com/wikidocs/images/drop_rows_result.png |
Revision as of 15:06, 24 January 2011
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:
http://www.international-presence.com/wikidocs/images/rules_dialog.png
Example
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:
http://www.international-presence.com/wikidocs/images/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:
http://www.international-presence.com/wikidocs/images/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}:
http://www.international-presence.com/wikidocs/images/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)