Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
pls clear explanation and syntex for concat function
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
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
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
];
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
];