ETL: CONCAT

Join a variable number of string expressions into one combined string. Use CONCAT for building composite fields in Integrate.io ETL pipelines.

Description

Concatenates a variable number of strings and returns them as one string.

Syntax

CONCAT(string_expression1, string_expression2[…, string_expressionN])

Examples

CONCAT('username','@xyzmail.com') returns ‘[e-mail]’

Return value datatype

String

Impact of null value

If input is null, returns null.