Difference between revisions of "Data Table Nodes"
From PresenceWiki
(4 intermediate revisions by 2 users not shown) | |||
Line 1: | Line 1: | ||
− | These Nodes | + | 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: | ||
− | + | * [[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. | |
− | + | * [[Append_Data_Column#Multiple_Column_Appender|Multiple Column Appender]] - Adds multiple columns to the Data Table | |
− | + | * [[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. | |
− | + | * [[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. | |
− | + | * [[Create Data Table]] - Creates a Data Table from scratch using custom values. | |
− | + | * [[Clear Data Table]] - Resets the Context Data Table to have zero rows and zero columns. | |
− | + | * [[Sort Data Table]] - Re-orders the rows in the Data Table according to the column order specified. | |
− | + | * [[Drop Duplicate Rows]] - Removes rows from the [[Data Table]] which are considered duplicates. | |
− | + | * [[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). | |
+ | |||
+ | |||
+ | == 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:
- 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</li>
- 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.
- Create Data Table - Creates a Data Table from scratch using custom values.
- Clear Data Table - Resets the Context Data Table to have zero rows and zero columns.
- Sort Data Table - Re-orders the rows in the Data Table according to the column order specified.
- Drop Duplicate Rows - Removes rows from the Data Table which are considered duplicates.
- 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).
See Also
Task Elements : Data Accesss Task Elements : Data Table Nodes