Difference between revisions of "Data Table Nodes"
From PresenceWiki
Line 7: | Line 7: | ||
<li>[[Require Columns]] - Tells the rest of the task that column names are available</li> | <li>[[Require Columns]] - Tells the rest of the task that column names are available</li> | ||
<li>[[Append Data Column]] - Adds an extra column to the Data Dable, populated with the value(s) specified.</li> | <li>[[Append Data Column]] - Adds an extra column to the Data Dable, populated with the value(s) specified.</li> | ||
− | <li>[[Multiple Column Appender]] - Adds multiple columns to the Data Table</li> | + | <li>[[Append_Data_Column#Multiple_Column_Appender|Multiple Column Appender]] - Adds multiple columns to the Data Table</li> |
<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> | ||
<li>[[Drop Row(s)]] - Drops one ore more rows from the Data Table depending on [[Rules]] set.</li> | <li>[[Drop Row(s)]] - Drops one ore more rows from the Data Table depending on [[Rules]] set.</li> |
Revision as of 10:35, 17 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:
- Data Filter - restricts data to that which has changed since the last execution time.
- Require Columns - Tells the rest of the task that column names are available
- Append Data Column - Adds an extra column to the Data Dable, populated with the value(s) specified.
- Multiple Column Appender - Adds multiple columns to the Data Table
- Drop Column - Drops a column of data from the Data Table
- Drop Row(s) - Drops one ore more rows from the Data Table depending on Rules set.
- Calculate Column Aggregate - Calculates averages, minimums, maximums and counts on the data.
- Dataset Splitter - Splits the data into chunks based on differing values. Each chunk uses a separate Execution Path.
- Merge Results - Merges chunks of data from separate execution paths into one Data Table.
- Clear Data Table - Resets the Context Data Table to have zero rows and zero columns.
- Sort Data Table - Re-orders the Data according to the column order specified.
- Store Data Table - Temporarily stores the Data in a Presence Variable for later use.
- Retrieve Data Table - Retrieves the temporarily stored Data Table (see above).