Concat with changing delimiter

[Alf_A]

Hi,

I wanted to know if it was possible to have a delimiter that changes per string. See example of what I'm looking for below:

Data:

Group	Date
A	18-May-15
A	12-Dec-15
A	20-Jul-15
A	14-Jun-15
B	15-May-15
B	16-May-15

'Date 1: ' & concat({<[Group]={'A'}>}[Date], [delimiter])

Output I'm looking for:

Date 1: 18-May-15 Date 2: 14-Jun-15 Date 3: 20-Jul-15 Date 4: 12-Dec-15

After the first value I'd like the delimiter to add a +1 . Is this possible?

[MarcoWedel · Accepted solution]

maybe like this?

Concat({<[Group]={'A'}>} Aggr('Date '&RowNo()&':'&Only(Date),Group,(Date, (Numeric, Ascending))), ' ')

hope this helps

Marco