diffeence

[#1]

what is the difference between concat and  concatenate

Thanks and regards

Madhu

[robert_mika]

CONCAT is a function

to aggregated string concatenation of all values of expression iterated over a chart dimension.

concat( Code, ';' )    

concat( FirstName&' '&LastName, ',' )

Concat Two Fields

Concatenate is used to merge two tables

Understanding Join, Keep and Concatenate

[maxgro]

Concatenate is a prefix for loading tables, only used in script. Concatenate appends the rows of one table (T2) to another (T1) previously loaded table. The result is one table (T1); the number of rows of the concatenated table (T1) is the sum of the number of rows of T1 and T2.

Concat is an aggregation function used to string / join together values/words/selections into one string.

Concat is used in script and chart.

The Concat Function

[reddy-s]

Hi Josna,

For your understanding, Concat can be classified as a string operation when 2 values can be merged together.

Whereas, Concatenate is used to merge 2 tables. Its similar to a Union All function in SQL.