Concat with changing delimiter

Alf_A — Tue, 26 Apr 2022 18:54:37 GMT

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:

'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?

Re: Concat with changing delimiter

MarcoWedel — Wed, 27 Apr 2022 10:51:56 GMT

maybe like this?

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

hope this helps

Marco