Data Transformer

Introduction

The Data Transformer allows a business user to define how the data of an RTX input should be transformed, filtered and amended within a process. RTX data will be transformed for further processing, for example create input lists for processes or prepare an insert into an Excel file. Bursting allows to create several RTX tables which are grouped by key fields. This can be used to split a large initial data into several packages for different organizations. At any stage, an intermediate result can be exported as RTX, HTML, Excel or PDF. It can be provided as additional tracking information.

Data types can be changed, for example text into numbers, you can define aggregations and filter criteria, or you add additional information like a prefix, as well as remove undesired or useless information, without needing technical expertise or scripting skills.

Open the Data Transformer

To open the Data Transformer, click on Control Center on the left-hand bar and press the Data Transformer icon on the tool bar.

To open the Data Transformer from the tool bar click on Control Center on the left-hand bar and press the Data Transformer icon on the tool bar.

Create a New Data Transformer Definition

On starting the Data Transformer, a popup appears allowing to open existing data transforming definitions or to create a new one. Creating a new Data Transformer will end up in a Data Transformer object, a definition which can be re-used in different processes.

When you press Create New, you will be requested to choose or drop an input file in a valid format (currently rtx).

As long the new Data Transformer definition is not saved, the name is "'Ruleset1". Press Save button and specify at least Partition An object used to store and isolate objects. and Name, the required information indicated with red stripes.