Transform data: concatenate fields based on groups

KNIME Analytics Platform
1

I read from database and have resulting query data like:

Group Value
1      A
1      B
2      A
2      C

I would like to transform to:

Group Sequence
1     AB
2     AC

What is good way to do this in KNIME? Thank you!

2

Use the "Group By" node with "Concatenate" as aggregation method. The separators added by this step can be removed with e.g. the String replacer node.

3

thor, this worked perfectly. Thank you!

4