Read more about Data Workbench’s End-of-life announcement.
The Merge transformation takes the values from the input field (typically a vector of strings), combines them into a single string separated by the given delimiter, and places the resulting string in the given output field.
Parameter | Description | Default |
---|---|---|
Name | Descriptive name of the transformation. You can enter any name here. | |
Comments | Optional. Notes about the transformation. | |
Condition | The conditions under which this transformation is applied. | |
Default | The default value to use if the condition is met and the input value is not available. | |
Delimiter | String that is used to separate the individual elements of the input string vector in the single output string. If you hold down the Ctrl key and right-click within the Delimiter parameter, an Insert menu appears. This menu contains a list of special characters that often are used as delimiters. |
|
Input | A vector of string values that are combined to form the output string. | |
Output | The name of the output string. |
In this example, an input vector of strings is assumed to contain a set of products that were selected for purchase. These products are placed into a single output string and are separated by “::” (two colons).
So if the input field x-products contained the string values B57481, C46355, and Z97123, the resulting output string x-show-products would be B57481::C46355::Z97123.