"Flattering" left join

For SQL solution, look at this link.

For workbench solution, assuming that id = index and a space is used as the separator:

Gives:

Note that your features have to be correctly ordered.

Regards,

Larry

or just the aggregator with a group by set to the index and attributes to concatenation are the strings using a space " " for separation

This can also be done using the Aggregator transformer, grouping by index.

Wow, thanks for many answers. In meantime I have found aggregator transformer but also ordering issue as mentioned by larry.

Many thanks again,

Submi