CONCATENATE - Joining Two or More Strings into One- FineDataLink Help Document

Last update: May 30, 2025

Overview

Syntax	CONCATENATE(Text 1/Date 1/Numeric 1, Text 2/Date 2/Numeric 2, ...)	Joins multiple values into one. Numeric values are directly converted to numeric strings for concatenation. (Decimal places are retained if any.) TIMESTAMP values are converted to a string in the YYYY-MM-DD HH:mm:ss format for concatenation. DATE values are converted to a string in the YYYY-MM-DD format for concatenation. If all values are NULL, the result is NULL. If one or more values are not NULL, a NULL text field is concatenated as an empty string.
Parameter	Text 1/Date 1/Numeric 1, Text 2/Date 2/Numeric 2, ...	The content to be merged into a single string, number, or date Note: 1. For FineDataLink of versions prior to 4.1.11.3, the parameters must be of the text type. The fixed number 123 can be concatenated using *CONCATENATE(Text, "123")*, but a numeric field cannot be concatenated using the function. 2. For FineDataLink of V1.11.3 and later versions, strings, numbers, and dates can be concatenated using the function.
Return Value Type	Text

Syntax

CONCATENATE(Text 1/Date 1/Numeric 1, Text 2/Date 2/Numeric 2, ...)

Joins multiple values into one.

Numeric values are directly converted to numeric strings for concatenation. (Decimal places are retained if any.)

TIMESTAMP values are converted to a string in the YYYY-MM-DD HH:mm:ss format for concatenation.

DATE values are converted to a string in the YYYY-MM-DD format for concatenation.

If all values are NULL, the result is NULL.

If one or more values are not NULL, a NULL text field is concatenated as an empty string.

Parameter

Text 1/Date 1/Numeric 1, Text 2/Date 2/Numeric 2, ...

The content to be merged into a single string, number, or date

Note:

1. For FineDataLink of versions prior to 4.1.11.3, the parameters must be of the text type. The fixed number 123 can be concatenated using CONCATENATE(Text, "123"), but a numeric field cannot be concatenated using the function.

2. For FineDataLink of V1.11.3 and later versions, strings, numbers, and dates can be concatenated using the function.

Return Value Type

Text

Example

Concatenating Text

For example, to join the Owner_Region field and Owner_City field into one, add a New Calculation Column operator in the Data Transformation node and input the formula CONCATENATE(Owner_Region, Owner_City), as shown in the following figure.

Click Data Preview to view the concatenated string in the new column, as shown in the following figure.

2.1-3.jpg

Concatenating Numeric

For example, to join two numeric fields into one, add a New Calculation Column operator in the Data Transformation node and input the formula CONCATENATE(Purchase Quantity, Contract Amount), as shown in the following figure.

Click Data Preview to view the concatenated string in the new column, as shown in the following figure.

2.2-3.jpg

Previous：REPEAT - Repeating Text a Specified Number of Times

Next：REGEXP - Determining If a String Matches a Regular Expression

Helpful
Not helpful
Only read

中文（简体）

English

CONCATENATE - Joining Two or More Strings into One

Overview

Example

Concatenating Text

Concatenating Numeric

附件列表