Difference between revisions of "Drop Row(s)"

From PresenceWiki
Jump to: navigation, search
(Drop Row(s))
 
(One intermediate revision by one other user not shown)
Line 5: Line 5:
 
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:
 
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
+
[[file:rules_dialog.png]]
  
 
=== Example ===
 
=== Example ===
Line 11: Line 11:
 
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:
 
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
+
[[file: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:
 
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
+
[[file: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
+
[[file:drop_rows_result.png]]
  
  
  
 
{{DataTableNodes}}
 
{{DataTableNodes}}

Latest revision as of 13:37, 21 August 2015

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

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:

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)