TRANSFORMER
Processes
Processes are used to select and manipulate data before sending it to the target.
To use a Process in a project, right click in the Transformer design panel, choose Process and the process you want to use.
Connect the elements by placing the mouse cursor over the connection dot on the first element's right side. Then click and hold the left mouse button while dragging the cursor toward the left side of the element you wish to connect to. Release the mouse button when the connection is correct.
Double click a process configure it. A process must be connected to the previous element before it can be configured.
The following processes are available:
-
Aggregation – used to perform these operations: SUM, AVG, COUNT, MIN, MAX
-
By default the BMP data record target performs similar aggregation functionality per periods (day, month, quarter, year etc.), and in many cases it may therefore
be unnecessary to use this function. -
Copy – used to copy a stream into two or more identical streams for further processing or to be sent to targets.
-
Merger - combines data from several streams into one stream.
-
Hierarchy – used to build node structures automatically and dynamically from a stream of data, e.g. for loading into a BMP database.
-
Set constant date - adds a fixed date.
-
RTF date conversion (relative to fixed) - adjusts a date with the value in a field.
-
Set date (relative to runtime) - adjusts a date relative to the date at runtime.
-
String date conversion - converts a column (string format) into a date column with desired date format.
-
Rich text conversion- retains any carriage returns (\r) from the source data after import.
-
Calculation – used to transform from number to string, select parts of strings, replace strings and perform simple calculations
-
Depivot conversion - reshapes data sets into a format that is more suitable for use in Transformer
-
Splitter - splits the data into different streams based on specified conditions
-
Node Mapping - manual node mapping; usually used with Node Target which has automatic node creation
-
Organization mapping – manually maps organizations found in a stream to organizations in the BMP database
-
Multi Calculation - used to perform several selections and operations at the same time
