Question

"Flattering" left join

How can I change something like this:

1Chris1Rock2John2Small

Into something like this:

1Chris Rock

2John Small

Thanks,

Submi

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

+16

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

Userlevel 2

+12

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

Sign up