Written by Thomas Speekenbrink
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
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
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'.
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.
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.
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.
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.
The result can be viewed on the Summary page. The Address column from the import file can be used twice.