Reformat
We suppose that you have already learned what is described in:
If you want to find the right Transformer for your purposes, see Transformers Comparison.
Short Summary
Reformat manipulates record’s structure or content.
| Component | Same input metadata | Sorted inputs | Inputs | Outputs | Java | CTL |
|---|---|---|---|---|---|---|
| Reformat | - |  | 1 | 1-N |  | |
Abstract
Reformat receives potentially unsorted data through single input port, transforms each of them in a user-specified way and sents the resulting record to the port(s) specified by user. Return values of the transformation are numbers of output port(s) to which data record will be sent.
A transformation must be defined. The transformation uses a CTL
template for Reformat, implements a
RecordTransform interface or inherits from a
DataRecordTransform superclass. The interface
methods are listed below.
Icon
Ports
| Port type | Number | Required | Description | Metadata |
|---|---|---|---|---|
| Input | 0 | | for input data records | Any(In0) |
| Output | 0 | | for transformed data records | Any(Out0) |
| 1-n | | for transformed data records | Any(OutPortNo) |
Reformat Attributes
| Attribute | Req | Description | Possible values |
|---|---|---|---|
| Basic | |||
| Transform | 1) | Definition of how records should be intersected written in the graph in CTL or Java. | |
| Transform URL | 1) | Name of external file, including path, containing the definition of the way how records should be intersected written in CTL or Java. | |
| Transform class | 1) | Name of external class defining the way how records should be intersected. | |
| Transform source charset | Encoding of external file defining the transformation. | ISO-8859-1 (default) | |
| Deprecated | |||
| Error actions | Definition of the action that should be performed when the specified transformation returns some Error code. See Return Values of Transformations. | ||
| Error log | URL of the file to which error messages for specified Error actions should be written. If not set, they are written to Console. | ||
Legend:
1): One of these must specified. Any of these transformation
attributes uses a CTL template for Reformat or
implements a RecordTransform interface.
See CTL Scripting Specifics or Java Interfaces for Reformat for more information.
See also Defining Transformations for detailed information about transformations.
Use Reformat To
Drop unwanted fields
Validate fields using functions or regular expressions
Calculate new or modify existing fields
Convert data types
CTL Scripting Specifics
When you define any of the three transformation attributes, you must specify a transformation that assigns a number of output port to each input record.
For detailed information about CloudConnect Transformation Language see Part XI, CTL - CloudConnect Transformation Language. (CTL is a full-fledged, yet simple language that allows you to perform almost any imaginable transformation.)
CTL scripting allows you to specify custom transformation using the simple CTL scripting language.
CTL Templates for Reformat
Reformat uses the same transformation teplate as DataIntersection and Joiners. See CTL Templates for Joiners for more information.
Java Interfaces for Reformat
Reformat implements the same interface as DataIntersection and Joiners. See Java Interfaces for Joiners for more information.