Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

what is meant by concat where it is return

pls clear explanation and syntex for concat function

3 Replies
danieloberbilli
Specialist II
Specialist II

Concat can return possible values as a string. 

E.g. you have a field 'Category' with the following values

Category

A

A

B

C

C

C

if you write (e.g. in a textbox):

Concat(DISTINCT Category, ' | ')   >> would return:   A | B | C

Anonymous
Not applicable
Author

Concat is a aggregate function which concatenates all possible values of any field...with a defined delimiter.

Field

xyz

abc

def

def

concat(Field,',') will return

xyz,abc,def,def

concat(distinct Field,',') will return

xyz,abc,def

first arguement is the field or expression which is to be concatenated and second arguement is the delimiter which should be used for delimiting the values

hariprasadqv
Creator III
Creator III

Hi,

Concatenation is for combining tables

It is of two types.

1. Auto Concatenation ( If both the tables are with same number of fields and with same names QV will implicitly concatenate the table no need of writing concatenation statement in between tables)

2. Forced concatenation (If number fields and field names are different then we have to use the keyword concatenate in between two tables.

Ex:1

Table1:

LOAD * INLINE [

    F1, F2

    1, 101

    2, 103

    3, 105

    4, 106

    5, 109

];

table2:

LOAD * INLINE [

    F1, F2

    11, 101

    22, 103

    33, 105

    44, 106

    55, 109

];

02.PNG

Ex:2

Table1:

LOAD * INLINE [

    F1, F2

    1, 101

    2, 103

    3, 105

    4, 106

    5, 109

];

Concatenate

table2:

LOAD * INLINE [

    F1, F3

    11, 101

    22, 103

    33, 105

    44, 106

    55, 109

];

12.PNG