Difference between revisions of "Drop Row(s)"

From PresenceWiki
Jump to: navigation, search
(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 ($67,530.00}:
+
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)