[Req] Grouper to have Concat/Unique Concat

Hellos,

I had like to request a feature for Grouper ,ability to CONCAT values with a delimiter , unique concat to ensure that duplicates aren't there.

Currently only number operations are possible.  This could be the first string based operation here.  I am aware that PIVOT can do this sort of grouping (non unique one) . 

 

I am not convinced that it is necessary,

you can group by multiple fields now or

of you want to concatenate fields there is a transformation for it 

www.etl-tools.com/wiki/advanced-etl-proc...laneous/concatenate/

I don't think transformation is possible here , concat items are on different 'rows' , not different fields.

Unless during grouping you can concat string values?

I am really struggelling to understand what you are trying to achieve

HI Mike,

Something like below, I have listed the operation on the 1st ROW

INPUT
 

OUTPUT
 

www.etl-tools.com/wiki/advanced-etl-proc.../accumulate-strings/

Use accumulate-strings transformation first on position field, 
Than use grouper and use last value option for position filed