...
The “Append text value” transformation allows for prepending and appending text to field values. Prefixing and suffixing tabs and new line characters are also supported.
Clean field
In the example below, we have chosen the transformation 'Clean field' to convert a value with leading zeros and non-digits to a numeric value.
...
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.
Tabs and new line characters as a delimiter can also be used.
On the Configure fields page, you can see the result of the merge.
...