CONCATENATE - Joining Two or More Strings into One

  • 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

    iconNote: 

    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

    附件列表


    主题: Data Development - Scheduled Task
    Previous
    Next
    • Helpful
    • Not helpful
    • Only read

    滑鼠選中內容,快速回饋問題

    滑鼠選中存在疑惑的內容,即可快速回饋問題,我們將會跟進處理。

    不再提示

    10s後關閉

    Get
    Help
    Online Support
    Professional technical support is provided to quickly help you solve problems.
    Online support is available from 9:00-12:00 and 13:30-17:30 on weekdays.
    Page Feedback
    You can provide suggestions and feedback for the current web page.
    Pre-Sales Consultation
    Business Consultation
    Business: international@fanruan.com
    Support: support@fanruan.com
    Page Feedback
    *Problem Type
    Cannot be empty
    Problem Description
    0/1000
    Cannot be empty

    Submitted successfully

    Network busy