Difference between revisions of "Data Table Nodes"

From PresenceWiki
Jump to: navigation, search
Line 3: Line 3:
 
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>[[Append_Data_Column#Multiple_Column_Appender|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>
+
* [[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 Data according to the column order specified.</li>
+
* [[Drop Duplicate Rows]] - Removes rows from the [[Data Table]] which are considered duplicates.
<li>[[Store Data Table]] - Temporarily stores the Data in a Presence Variable for later use.</li>
+
* [[Store Data Table]] - Temporarily stores the Data in a Presence Variable for later use.
<li>[[Retrieve Data Table]] - Retrieves the temporarily stored Data Table (see above).</li>
+
* [[Retrieve Data Table]] - Retrieves the temporarily stored Data Table (see above).
</ul>
+

Revision as of 11:07, 22 June 2010

These Nodes allow you to manipulate the Presence Data Table by filtering out data, dropping rows, columns, adding columns, etc.

The following Nodes are currently available: