Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
what is the difference between concat and concatenate
Thanks and regards
Madhu
CONCAT is a function
to aggregated string concatenation of all values of expression iterated over a chart dimension.
concat( Code, ';' )
concat( FirstName&' '&LastName, ',' )
Concatenate is used to merge two tables
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.
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.