http://wiki.clovergui.net/ 2010-09-05T12:29:42+02:00 http://wiki.clovergui.net/ http://wiki.clovergui.net/lib/images/favicon.ico text/html 2009-09-16T12:27:17+02:00 http://wiki.clovergui.net/doku.php?id=components:aggregate_old&rev=1253096837&do=diff Aggregate (Clover version 2.1 or older) Aggregate functions are applied on input data flow base on specified key. The key is name (or combination of names) of field(s) from input record. Data flow can be sorted or not. On this component you cannot set any transformation function to map aggregation results on the output metadata. Output metadata has to correspond accurately to the settings of aggregate component. Key of aggregation is mapped first and then follow all aggregate function results. text/html 2009-11-13T13:04:17+02:00 http://wiki.clovergui.net/doku.php?id=components:bulkloaders&rev=1258113857&do=diff Bulk loaders are components of graph that writes data to output database. These components load data to database using database utility. It is faster than DBOutputTable. Load formats data pages directly, while avoiding most of the overhead of individual row processing that inserts incur. text/html 2009-09-16T12:27:17+02:00 http://wiki.clovergui.net/doku.php?id=components:deprecated&rev=1253096837&do=diff DelimitedDataReader This component is deprecated. Use DataReader instead. Parses specified input data file and broadcasts the records to all connected out ports. Input ports: * one optional input port defined/connected (port protocol see fileURL). text/html 2009-09-16T12:27:17+02:00 http://wiki.clovergui.net/doku.php?id=components:joiners&rev=1253096837&do=diff Joiners are components of graph that join data from all connected input ports based on defined key and propagate the result to output port. Transformations In either of these components, you must define some transformation using the transform() function. In addition to this required function, you can define other two functions: init() and finished(). If you want to declare and initialize some variables, if you want to anything what should be done at the beginning of data processing … text/html 2010-07-14T10:39:25+02:00 http://wiki.clovergui.net/doku.php?id=components:others&rev=1279096765&do=diff This components perform various operations like data verification, command performing and so on. ---------- Attribute Description Exp. id component identification string type component type. This attribute is automatically generated from gui. string text/html 2010-06-10T15:55:34+02:00 http://wiki.clovergui.net/doku.php?id=components:readers&rev=1276178134&do=diff Readers are initial components of graph that reads data from input source. The source can be for example a file placed on local disk, ftp, ldap, jms or database tables, etc. Graph must contain at least one of these components or more. ---------- text/html 2010-07-12T21:47:26+02:00 http://wiki.clovergui.net/doku.php?id=components:transformers&rev=1278964046&do=diff Transformers are components of graph that transform data from one or more input ports to output port. Most of transformers use transform function or key or some other method that defines particular data transformation. Note: For characters that are impossible to enter directly, there are several escape sequences: \\, \n, \t, \r, \”, \f, \b. So be careful when using “\” character, eg. parameter filterExpression=“$Field1~="([^\\|]*\\|){3}"” will be interpreted as “$Field1~="([^\|]… text/html 2010-07-21T08:54:03+02:00 http://wiki.clovergui.net/doku.php?id=components:writers&rev=1279695243&do=diff Writers are terminated components of graph that writes data to output source. The source can be for example a file placed on local disk, ftp, ldap, jms or database tables, etc. Graph must contain at least one of these components or more. ----------