Concat function

[qlikview979]

Hi Experts,

What is Concat function?  when will we use this? please share with example?

Regards,

Mahesh

[Anonymous]

In namelist2 column i want the column "name" values which are not matching with its id using concatenation..

so the result for your example should be as follows:

department  Name  Namelist2

1                    A,B     C,D,E,F

2                    C,D    A,B,E,F

3                    E,F     A,B,C,D

this result i am expecting.

[Anonymous]

Hi,

In Qlikview,

If you have two tables with same structure and with same number of fields along with same data qlikview automatically concatenate both the tables.

and

if you have to concatenate the tables in other scenarios (means...if you  don't have tables with same structure)  you can use the 'concatenation'  statement to combined these both tables.

and

if you have to combined the two fields,you can use the & (concatenation symbol) in both the script and front end(like...in calculated expression or  in calculated dimensions).

[#4]

I think Concate is used to merge the record values and Concatenate is merge the fields