data
| ID | Value |
| a | 5 |
| a | 1 |
| a | 8 |
| a | 2 |
| a | 3 |
| b | 1 |
| b | 2 |
| b | 3 |
| b | 8 |
| b | 4 |
| c | 9 |
| c | 1 |
| c | 5 |
result
| ID | Value |
| a | 1;2;3;5;8 |
| b | 1;2;3;4;8 |
| c | 1;5;9 |
i can only use node"string manipulation" with another column
but i can't make that result
besides, real data is very big.
I hope you do me a favor.
PS if you upload workflow, i will love you.
Hi,
you can do this with a groupby node (group by on ID and aggregation by concatenation on Value).
After this node you can sort the string in Value with a java snippet
If you do not want to use the java snipplet but prefer to do everything in knime, then first sort the data with the normal sort node, but sort on both columns, Primary on ID and secondary on Data.
Then your data will be presorted and look like
| ID | Value |
| a | 1 |
| a | 2 |
| a | 3 |
| a | 5 |
| a | 8 |
| b | 1 |
After that, as darbon suggested, use the group by node.