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.
|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.|
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.