The Concat transform creates a string concatenation, enabling you to retrieve data from two or more entities and link them into a single result.
The Concat transform concatenates two or more strings from the input into a single string value in the output. You can specify a prefix, postfix, and delimiters through the Properties pane:
You can specify an alphanumeric character to be the delimiter between the strings, as well as a string prefix and a string postfix.
For example, you can concatenate the strings from the elements firstname and lastname, and specify a space as the delimiter, a prefix of Mr. , and a comma as the postfix, with the following result: Mr. firstname lastname,