Concatenate

Links string1 with string2 and returns the result as a concatenated string.

If one of the strings is null then returns the other.

If both are null then returns null.

Example: building a full customer name:

Your incoming order data has separate FirstName and LastName fields, and you need a single FullName field for the outbound document.

• SourceString1 = FirstName → "Jane"
• SourceString2 = LastName → "Doe"

Running Concatenate gives you:

• Result: "JaneDoe"

Since Concatenate just joins the two strings directly with no separator, you'd typically nest it - e.g., first concatenate FirstName with a literal " " (space) string, then concatenate that result with LastName — to get "Jane Doe".

Another common use: building a composite key or filename, like combining an OrderNumber with a .xml extension to produce "ORD12345.xml" for an outbound file name.