Skip to content

Data transformer

With this app you can transform the data of the io-link sensors, boolean data is not supported. The transformation can be done applying up to two mathematical operations, modifying the process data variable name and or the unit. To install the Data Transformer app, download from the APP store and install it on the CMTK.


The Data Transformer app can then be found under Settings > Apps > Data Transformer

Data Transformer

Add new Transformation

To add a new transformation, you should press the Add Transformation button:

Add Transformation button

This will open a dialog. First you have to select the io-link sensor:

Dialog device selection

To continue, click on Next.

Now you can select the process data variable and click on add transformation:

Dialog process data selection

You can now modify the process data variable name and or the unit.

Dialog modify variable name and unit

If you need apply mathematical operations, you can add up to two operations (addition, subtraction, multiplication, division) and set the value to apply.

Dialog mathematical operations

In the last step, you get a summary with the original values and the transformed values.

Dialog summary

If you click on Finish, the transformation will be saved.

Edit Transformation

To edit a transformation, you should press the Edit button in the corresponding row of the table:

Edit button

This will open the same dialog as when creating a new transformation, but with the current settings loaded. You can now change the settings as needed and click on Finish to save the changes.

Edit transformation dialog

Delete Transformation

To delete a transformation, you should press the Delete button in the corresponding row of the table:

Delete button

To finish the deletion, you need to confirm it:

Confirm delete dialog

Most used transformations

Temperature Conversion

To convert a temperature value from Celsius to Fahrenheit, you can use the following settings:

  • Mathematical Operation 1: Multiplication, Value: 1.8
  • Mathematical Operation 2: Addition, Value: 32

To convert from Fahrenheit to Celsius, you can use:

  • Mathematical Operation 1: Subtraction, Value: 32
  • Mathematical Operation 2: Division, Value: 1.8

To convert from Celsius to Kelvin, you can use:

  • Mathematical Operation 1: Addition, Value: 273.15

Linear Scaling

To scale a value linearly, you can use multiplication and addition. Its necessary to obtain the scaling factor and the offset. To apply the scaling equation first you need to identify the minimum and maximum values of the original range and the desired range. For example, to scale a value from the range [4, 24] to the range [0, 100], you can use the following settings:

  • Xmin = 4, Xmax = 24

  • Ymin = 0, Ymax = 100

  • Scaling Factor (m) = (Ymax - Ymin) / (Xmax - Xmin) = (100 - 0) / (24 - 4) = 5

  • Offset (b) = Ymin - m * Xmin = 0 - 5 * 4 = -20

Then, you can set the mathematical operations as follows:

  • Mathematical Operation 1: Multiplication, Value: 5
  • Mathematical Operation 2: Addition, Value: -20