How can I change something like this:
1Chris1Rock2John2SmallInto something like this:
1Chris Rock2John Small
Thanks,
Submi
Question
"Flattering" left join
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
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
+18- Supporter
or just the aggregator with a group by set to the index and attributes to concatenation are the strings using a space " " for separation
Wow, thanks for many answers. In meantime I have found aggregator transformer but also ordering issue as mentioned by larry.
Many thanks again,
Submi