Search results

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

• Debug
  ...he pane to the right. The [[Data Table]] is presented as a tree, with each column name as a branch and each row as a leaf within the branch. [[Variables]] are displayed under the Data Table and are split into Local and [[Task Variables]]. Global Variables are not d
  4 KB (713 words) - 15:00, 19 August 2015
• Performance
  For each task clear the data tables and variables, this will save system thread and memory resources. This is just a small query on a small table to let Presence know whether the connection for that resource still exists
  4 KB (680 words) - 14:42, 20 August 2015
• Object Monitor Nodes
  ...ging together traditionally non-compatible data sources - SQL data and web data - to provide a fully integrated solution to a business problem. ...select the Category in the Task Explorer then right click anywhere in the Data Access List, and Select Create New Object Monitor.
  15 KB (2,761 words) - 15:34, 19 August 2015
• POP Scanner
  ...ce Task in exactly the same way as other data sources to provide alerts or data integration facilities. ...select it from the right click menu or drag the Pop scanner icon from the Data Access list.
  22 KB (3,837 words) - 13:58, 20 August 2015
• Web Services Nodes
  To create a Web Service Call, drag the icon from the Data Access / Web Services area of the Task Elements list: ...Context. The Web Service task element can empty the Presence Context data table before the call or can merge the results of the call with the existing data
  7 KB (1,150 words) - 14:09, 20 August 2015
• Data Table Nodes
  ...e concerned with manipulating the Presence [[Data Table]] by filtering out data, dropping rows, columns, adding columns, etc. * [[Data Filter]] - restricts data to that which has changed since the last execution time.
  2 KB (257 words) - 15:58, 24 January 2011
• Data Filter
  .... For example, to perform different functions when new, changed or deleted data is detected. ...arge daily and weekly reports are produced and the recipient must sift the data manually looking for exceptions.
  7 KB (1,139 words) - 15:38, 20 August 2015
• JMS Consumer
  ===Incoming Message Data=== ...ield names. In order to receive a test message, click the "Receive Message Data" button. Progress information will be displayed in the text area beneath th
  4 KB (575 words) - 11:11, 23 June 2010
• CSV Writer
  The CSV writer formats the current data table from the [[Presence Context]] and outputs it to a Presence variable, or to For example, the following table of data:
  2 KB (395 words) - 12:50, 14 July 2010
• HTML Table Writer
  ==HTML Table Writer== ...TML Table Writer node outputs the current Presence Context data as an HTML table.
  1 KB (159 words) - 13:57, 21 August 2015
• Presence Context
  * The current [[Data Table]] ===Data Table===
  2 KB (391 words) - 10:36, 20 August 2015
• Custom Data Formatter Standard Option
  ...d on the incoming Data Table. For example, consider the following table of data: ...country field is not. It would therefore make sense, when presenting this data, to provide sub-headers for the country field. So, let's suppose we wanted
  6 KB (1,018 words) - 12:47, 21 August 2015
• Decision Point Nodes
  ...Paths]] depending on the result of a test. Typically the test will involve data that has reached the Node from earlier in the Task (for example a [[Variabl ...the value that you wish to test. Typically this will be a Variable, a Data Column or a [[Function Call]] result. Or it may be a combination of the above.
  3 KB (520 words) - 09:58, 20 August 2015
• SQL Statement Nodes
  SQL Statement Nodes allow you to run SQL statements against a JDBC-compliant data source such as Oracle, Microsoft SQL Server, MySQL, etc. ...cause the structure tree to be loaded into the left hand pane. Selecting a column will bring up extra information in the panel below the tree.
  12 KB (2,047 words) - 11:12, 20 August 2015
• Mail Scanner Nodes
  ...l accounts and retrieve emails, and then convert them into a Presence Data Table. This is especially useful for creating automated processes based on emails ...your Task, either drag Task Element labelled "Scan Mail Accounts" from the Data Access toolbox, or right-click on your Task and choose "Insert New > Mail S
  7 KB (1,251 words) - 14:01, 20 August 2015
• XML Query Tool
  ...perform queries against XML documents and convert the results into a Data Table which is stored in the [[Presence Context]] for reference by subsequent Nod ...he document into a flattened table structure (which is how Presence stores data). Because XML documents are multi-dimensional and the relationships between
  5 KB (897 words) - 10:26, 20 August 2015
• Basic XML Writer
  The Basic XML Writer Node converts the current Data Table into a basic XML structure as follows: Based on the following input Data Table:
  2 KB (235 words) - 16:13, 19 August 2015
• XML Document Writer
  * Incoming Data Table To create an XML Document Writer, simply drag the Node from the Data Formatters list into your Task. You will then be presented with the XML Doc
  3 KB (606 words) - 16:14, 19 August 2015
• FTP Upload
  ...files\document.txt), a variable reference (e.g. ${myfile}) or a data table column reference (e.g. :var{FILENAME}). ...umn reference is used and multiple (distinct) rows are present in the data table, each variant value will be used as the basis of forming the filename. For
  4 KB (618 words) - 10:08, 20 August 2015
• Function Call
  ...Dynamic text can include [[Variables|Variable]] references, [[Data Table]] Column References and Function calls. When Presence encounters dynamic text it is
  5 KB (787 words) - 08:55, 14 August 2015
• 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