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.
Text 1/Date 1/Numeric 1, Text 2/Date 2/Numeric 2, ...
The content to be merged into a single string, number, or date
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.
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.
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.
滑鼠選中內容,快速回饋問題
滑鼠選中存在疑惑的內容,即可快速回饋問題,我們將會跟進處理。
不再提示
10s後關閉
Submitted successfully
Network busy