Search results

Create the page "Data Table Column" on this wiki! See also the search results found.

• Scriptlet
  ...the current data table and variables set. For example, if you have a data table in the Presence Context which contains the columns FORENAME and SURNAME and ...c. Assuming the surname is stored in a column named "SURNAME", this append column node will fix the problem:
  7 KB (1,140 words) - 12:36, 20 August 2015
• Create Graph
  === Graph Type and Data Tab === * '''Label Series Column''' - The value for this should be a Presence data table reference - e.g. :var{labels}. If we consider a pie graph to consist of nam
  13 KB (2,275 words) - 14:26, 21 August 2015
• Rules
  ...u to specify a Rule. If the Rule does not evaluate for a particular row of data the Task Element will not affect that row. These include (at the time of wr * [[Append Data Column]] - rows that do not match the Rule will be set to NULL
  4 KB (762 words) - 15:51, 3 September 2015
• Append Data Column
  === Append Data Column === This Node appends an extra Data Column to the Presence Data Table with the value specified in the input dialog:
  3 KB (467 words) - 12:35, 21 August 2015
• Drop Column Node
  == Drop Column == ...drops individual columns from the current [[Data Table]]. Dragging a Drop Column node into your Task will present the following dialog box:
  989 B (170 words) - 13:36, 21 August 2015
• Drop Row(s)
  This Node (selectively) deletes records from the current [[Data Table]]. ...company. Our initial data table (which we'll create with the [[Create Data Table]] node) contains the following:
  1 KB (171 words) - 13:37, 21 August 2015
• Data Table
  === Data Table === The Data Table is an object stored in memory as part of the [[Presence Context]]. It consi
  5 KB (887 words) - 10:40, 20 August 2015
• Calculate Column Aggregate
  == Calculate Column Aggregate == ...orms the following statistical functions on a column of data in the [[Data Table]]:
  5 KB (728 words) - 13:25, 21 August 2015
• Dataset Splitter
  ...ich appear in a specified column. For example, consider the following Data Table: If we split the data over the "Group" column, this will divide the Table into four sub-tables, illustrated below:
  969 B (156 words) - 12:52, 20 August 2015
• Merge Data
  == Merge Data == ...Merge Data Node is responsible for merging together different [[Data Table|Data Tables]]. These may come from separate execution paths or from one [[iterat
  3 KB (471 words) - 13:53, 21 August 2015
• Sort Data Table
  ...ained. Below is the dialog box that is presented when dragging a Sort Data Table Node into your Task: ...xt column will be considered, and if those values are also equal the third column will be considered - and so on.
  1 KB (207 words) - 12:44, 21 August 2015
• Set Variable
  ...iable value may also reference another Presence variable, a [[Data Table]] column value, or a function call - or any combination of these. The following are ...lue of a variable? Given that Presence uses implicit iteration (see [[Data Table]] discussion page) one might expect all potential values to be included in
  2 KB (270 words) - 10:35, 20 August 2015
• Web Service Properties
  ...ing variables and data table to include exposed and required variables and data columns within the Task. ...data columns, translated into message parts, and the output variables and data columns. Clicking the "Synch Now" button will automatically populate these
  2 KB (297 words) - 12:43, 20 August 2015
• Read Bar Code
  ...riables, data table values or function calls. If the value is taken from a column name then a separate scan will be performed for each unique value. === Generated Column Names ===
  4 KB (667 words) - 09:47, 23 September 2015
• Custom Nodes
  ...the purpose. The example below is for logging audit messages to a database table. ...ther the iteration strategy should ignore duplicate values (in the case of column variables) or process duplicate values.
  6 KB (934 words) - 13:32, 21 August 2015
• JSON Node
  ...e internet or a local file location and converts it into a Presence [[Data Table]] after applying rules. === Example JSON Document and resulting Presence Data Table ===
  3 KB (560 words) - 16:00, 19 August 2015
• Flat File Parser
  ...character-delimited fields and converts the contents into a Presence data table. To create a new Flat File Parser in your Task, drag the task element from the Data Access toolbox into the task edit pane. You will then be presented with the
  6 KB (1,015 words) - 15:44, 19 August 2015
• Functions
  ...ing this helps to ensure the parser can recognise the start and end of the data. ==== Data Functions ====
  41 KB (6,004 words) - 11:05, 7 September 2015
• Parse File Action
  The purpose of this node is to convert data found within a file into a dataset. *RTF Table
  5 KB (922 words) - 15:43, 19 August 2015
• Create Data Table
  == Create Data Table == ...n be useful for testing or just when you wish to include a table of static data.
  2 KB (398 words) - 10:38, 20 August 2015
• Synchronize Blocks
  ...sive lock based on the key provided (this can be dynamic and based on your data). If no other Tasks have managed to obtain this lock, it will be returned i The following columns are displayed in the table. Click on a column header to sort the locks by that criteria.
  2 KB (407 words) - 13:17, 20 August 2015
• Loop Until
  ...Multi_Column_Text_Split|Multi-Column Split]] to create a [[Data Table|Data Table]] (for the Graph Node) from the ${sine_array} and the ${sine_iteration_arra 9 Creates the Sine graph from the Data Table.
  3 KB (513 words) - 11:00, 7 September 2015