Transformations - Use Cases

Last update:
Created :
Written by Thomas Speekenbrink

Overview:

This articles contains Tips & Tricks on the use of transformations in Nebula DataBridge.
It is an article in progress and we would love your input also. So if you have a use case or have an idea about a new transformation please send us an email at support@infobridge

More info on import transformations
More info on export transformations

Use cases:

Replace

In an import file you have a column called 'paying customer'. It contains the values Yes and No. You want to import this information into Superoffice and make it visable by using the Stop sign in SuperOffice. The problem is that Yes will activate the Stop sign.

The solution is to create two Replace Transforms. With the first you replace Yes with 0 and you use the second transform to replace No with 1

TransformT_T04.png

In the second step of the Profile configuration 'Configure Source' you can see the data from the import file. After the transformations the result can be seen in step 4 'Configure Fields'. 

TransformT_T03.png

 

Replace

Another Replace transform can be used in case you have a file with empty fields in the import file.
For instance, you have a column 'Our contact' which you want to import. But not all fields in this column are filled in. 
You can use the Replace transform where you choose to leave the first field empty and fill the second filed with an associate from SuperOffice to be used as 'our contact. See the example below.

TransformT_T05.png

In the second step of the Profile configuration 'Configure Source' you can see the data from the import file. After the transformation the result can be seen in step 4 'Configure Fields' as you can see below.

TransformT_T06.png

 

Merge fields

The import file has the address and homenumber in seperate columns. You can use the Merge fields transform to merge the two columns with a delimiter of your choice.

In this example the fields Address and Number will be merged into a new output field Street address. As a delimiter a space is used.

transform10.png

 

Copy field

We want the data from the address column in the import file to be also used for the postal address. This can be achieved by choosing the Copy Field transfrmation.

Transform16.png

The result can be viewed on the Summary page. The Address column from the import file can be used twice.

Transform17.png

 

Format text value

Besides formating text values to upper or lower case, among others, we have now also introduced a new format option called Trim. This will remove all leading and trailing white-space from the value in the fields.

Transform14.png

 

Add field

When importing data you can add a new field with a fixed value. Say you want to import a file containing projects and you want to link these to companies in SuperOffice. In the file itself you have no field for Project Responsible (mandatory).

You can now add a field called Responsible and add an associate from SuperOffice

transform_add_field1.png

To link the projects to a company you need to add another field, 'Helper' field, to make the link between company and Project, more info

transform_add_field2.png

In the next step 'Configure fields' you can link these new fields to the correct SO fields.

transform_add_field3.png