ALLTEK Systems cc

Data transformation

Aggregation

Filter

Flatten

Hierarchy

Map

Sort

Translate

Connector

The image on the left shows the preview screen indicating the result of the transformation taking place to the right of the screen.

Below is an example of a VBScript or function being used to determine field value. This may include a forward lookup into a database or Accpac.

Transforms form the core of Iman. They provide the capability to manipulate data. By connecting several transforms together in a chain, data can be manipulated into virtually any form.

Data Shaping Transforms

IMan has three transformations to shape data:

Hierarchy –Transforms any record type within a data structure to a hierarchical structure. Because the transform acts on a single record type it allows you to either transform a completely flat data structure consisting of just a single record type or to add a further hierarchical element(s) to a pre-existing structure. An example would be header and detail sections of an invoice.

Flatten – Flatten is the converse of hierarchy. Flatten takes either a full dataset or a group and its children transforming it into a flat structure with no hierarchy.

Aggregation – Transforms a logical group records to a single record. In a typical sense, aggregation supports operations such sum, count, min, max. However its broad flexibility allows you to generate a record(s) which are a derivative from other records within the same group. An example would be a sales file from a POS system is used to create nominal journals in an accounting system. To balance the nominal journal an aggregate transform generates a balancing record, which is the negative sum of other lines in the journal.

Field Level Transformations

Map - The Map transform is a formula based transformation. Each field in the transform has facility to execute a VBScript expression or function, in which the result becomes the value of the field.

Translate – Provides a means to translate the names of records, fields and their types. The translate transform provides a means to quickly adapt existing integrations to new data sources.

Record Level Transformations

Filter – The Filter Transform filters/deletes records from a dataset using an expression.

Sort – Multi-level sorting within a dataset.