topic diffeence in QlikView

diffeence

Sun, 13 Dec 2015 08:57:55 GMT

what is the difference between concat and concatenate

Thanks and regards

Madhu

Re: diffeence

robert_mika — Sun, 13 Dec 2015 09:15:56 GMT

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

Re: diffeence

maxgro — Sun, 13 Dec 2015 09:23:26 GMT

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

Re: diffeence

reddy-s — Sun, 13 Dec 2015 10:46:51 GMT

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.