Concat and relative values

[#1]

Hi all,

I have a table:

Company 1

Company 1

Company 2

Company 3

I would like it to be aggregated in a following way:

[Company 1]2;[Company 2]1;[Company 3]1

Is there any possibility to add values to concat() function? Or maybe anyone could give a hint which function can be used instead?

Thanks

[hector]

Hi, for this script

TMP_DATA:
LOAD
 *
INLINE [
F0, F1
All Companies, Company 1
All Companies, Company 1
All Companies, Company 2
All Companies, Company 3
];

DATA:
Load
 F0,
 concat(distinct '['& F1 & ']' & C,';') as F1_Concat
group by
 F0
;
Load
 F0,
 F1,
 count(F1) as C
resident TMP_DATA
group by
 F0,
 F1
;

drop table TMP_DATA;

This is my result

Rgds