Chained transformations

Overview

Transformations can now be chained together so the field created by a transformation can be further transformed.

How to

Let’s explain how this works with the following examples.

Example A

From an import file we need the VAT number. It has to be added to SuperOffice as Country code + number

In the importfile the VAT number consists out of spaces, dots and periods.

Open

First the VAT number needs to be cleaned with the Clean Field transformation.

Open

Next job is to create a country code column. With the Map List transformation this can be achieved. Where country in the Country column in the import file is Netherlands the output is NL in a new column Country Code.

Last job is to merge the VAT nr and the Country Code. This can be done with the Merge Fields transformation. The column Country code (created in the previous transformation) and the VAT number need to be merged to a new column VAT + Country. This new column can be mapped to the SuperOffice field VAT no.

By using chained transformations we have managed to import a value from an import file and transformed it to a usable value for SuperOffice.