Transform your data

What to expect in this guide

Data transformation enables you to create more meaningful content by adding phrases to the values and setting up the data applied to the selected function.This guide will give you an overview of several components that can be used to transform data. It shows how to implement mapping nodes as well as the purpose of lookup tables. In any of both cases you define an input and apply the changes to it.

Get the most out of your data with mapping nodes

Any kind of modification of your data can be done with a mapping node. This includes many different applications:

  1. One possible scenario is to fix spelling errors or handle upper and lower case.

  2. Another option is to insert mapping nodes for several list functions, such as counting, filtering and sorting.

  3. And you also can use it to do calculations with data values that can vary.

Note: Anything you have to change in your data so you can use it in the text, you can do within a mapping node.

Structure of mapping nodes

First of all every mapping node has a unique name, similar to the other node types. The input ports are used to put the needed data into this node. By clicking on ADD PARAMETER a parameter will appear with the corresponding port. The number of input ports depends of the functions and data values that you want to involve. mapping node

The truth port accepts truth values from other nodes. It determines if the output can be used (green light) or not (red light), depending on the defined logic. The mapping expression is the part of this node that tells how the data has to be modified. You can use the functions in our documentation to apply the operations to the input data. The output port delivers the output of this node and can be connected to another node. The data flow is from left to right. You use an input to get a specific output, in general you map an input to an output. The preview shows the output of the node with the current settings. It helps you to make sure that you have set everything correctly.

In this example two values are combined in a mapping node so that the output can be called with one phrase variable. mapping node

Modify data values

One single mapping node can be sufficient to change the value for all affected data sets. On a side note regular expressions can also be implemented for that. In the following you will create a mapping node to replace a value.

Create a mapping node!

  • Use mapping node to remove values and clean up data

Applying list functions

Several list operations like count, unique and filter can also be applied by using mappings. The input in this case should be always a list. Either you already have a list in your data, or you can create your own. The following tutorial shows you a good use case for the sort function.

Implement a list expression!

  • Use mapping node for sorting values in a list

Additional information by using lookups

Lookup tables are an easy way to transform the data and add more information. There are several scenarios in which the tables are used:

  • For translating the data values

They enable you to create a multilingual project data even if the data is only available in one language

  • For enriching the data by assigning phrases

The enrichments give the text individuality and deliver more valuable content to the reader, thus increasing the text's quality.

In addition, these tables are a very clear option to display a lot of information.

Structure of lookup tables

The lookup tables are displayed as a typical table with a key-value structure. As key you add the value from the data, it has to match the string you want to replace. As value you add the phrases you want to assign to the key. If you have a multilingual project, you can add the corresponding entry for every language. lookup table

Match the table with the data

Once you have set up the look up table with the entries, you have to connect the table with the data node. Here you need a mapping to merge the two inputs. lookup mapping

Integrate a lookup table!

  • Create a lookup table and use it in a statement