Difference between revisions of "Data Table Nodes"

From PresenceWiki
Jump to: navigation, search
 
 
(5 intermediate revisions by 2 users not shown)
Line 1: Line 1:
These Nodes allow you to manipulate the Presence [[Data Table]] by filtering out data, dropping rows, columns, adding columns, etc.
+
These Nodes are concerned with manipulating the Presence [[Data Table]] by filtering out data, dropping rows, columns, adding columns, etc.
  
 
The following Nodes are currently available:
 
The following Nodes are currently available:
  
<ul>
+
* [[Data Filter]] - restricts data to that which has changed since the last execution time.
<li>[[Data Filter]] - restricts data to that which has changed since the last execution time.</li>
+
* [[Require Columns]] - Tells the rest of the task that column names are available
<li>[[Require Columns]] - Tells the rest of the task that column names are available</li>
+
* [[Append Data Column]] - Adds an extra column to the Data Dable, populated with the value(s) specified.
<li>[[Append Data Column]] - Adds an extra column to the Data Dable, populated with the value(s) specified.</li>
+
* [[Append_Data_Column#Multiple_Column_Appender|Multiple Column Appender]] - Adds multiple columns to the Data Table
<li>[[Multiple Column Appender]] - Adds multiple columns to the Data Table</li>
+
* [[Drop Column]] - Drops a column of data from the Data Table</li>
<li>[[Drop Column]] - Drops a column of data from the Data Table</li>
+
* [[Drop Row(s)]] - Drops one ore more rows from the Data Table depending on [[Rules]] set.
<li>[[Drop Row(s)]] - Drops one ore more rows from the Data Table depending on [[Rules]] set.</li>
+
* [[Calculate Column Aggregate]] - Calculates averages, minimums, maximums and counts on the data.
<li>[[Calculate Column Aggregate]] - Calculates averages, minimums, maximums and counts on the data.</li>
+
* [[Dataset Splitter]] - Splits the data into chunks based on differing values. Each chunk uses a separate [[Execution Path]].
<li>[[Dataset Splitter]] - Splits the data into chunks based on differing values. Each chunk uses a separate [[Execution Path]].</li>
+
* [[Merge Results]] - Merges chunks of data from separate execution paths into one Data Table.
<li>[[Merge Results]] - Merges chunks of data from separate execution paths into one Data Table.</li>
+
* [[Create Data Table]] - Creates a Data Table from scratch using custom values.
<li>[[Clear Data Table]] - Resets the Context Data Table to have zero rows and zero columns.</li>
+
* [[Clear Data Table]] - Resets the Context Data Table to have zero rows and zero columns.
<li>[[Sort Data Table]] - Re-orders the Data according to the column order specified.</li>
+
* [[Sort Data Table]] - Re-orders the rows in the Data Table according to the column order specified.
<li>[[Store Data Table]] - Temporarily stores the Data in a Presence Variable for later use.</li>
+
* [[Drop Duplicate Rows]] - Removes rows from the [[Data Table]] which are considered duplicates.
<li>[[Retrieve Data Table]] - Retrieves the temporarily stored Data Table (see above).</li>
+
* [[Store Data Table]] - Temporarily stores the Data in a Presence Variable for later use.
</ul>
+
* [[Retrieve Data Table]] - Retrieves the temporarily stored Data Table (see above).
 +
 
 +
 
 +
== See Also ==
 +
 
 +
{{DataAccess}}

Latest revision as of 15:58, 24 January 2011

These Nodes are concerned with manipulating the Presence Data Table by filtering out data, dropping rows, columns, adding columns, etc.

The following Nodes are currently available:


See Also

Task Elements : Data Accesss Task Elements : Data Table Nodes

SQL Statement Nodes | Object Monitor Nodes | XML Query Nodes | Mail Scanner Nodes
Web Services Nodes | LDAP Query Nodes | JSON Node | Flat File Parser | Data Table Nodes | Variable Nodes
Transaction Control Nodes | Context XML Nodes


Task Elements | Resources