table row in Columns // Newbie Question

[werwurm01]

Hello Together,

As an Newbie at Knime i should ask a maybe stuid question. I did’t find any suggestion on Google, due to correct search tags.

I have a simple Table:
Row ID - Name - Value
0 - X - 1
1 - X - 2
2 - X - 3
3 - Y - 1
4 - Y - 2
5 - Z - 1

A table like followed is needed.
Row ID - Name - Value
0 - X - 1 / 2 / 3
1 - Y - 1 / 2
2 - Z - 1

In which way it can be realized? Of Course with Loops but i didn’t know any starting point.

Can anyone help me?

Best Regards,
Marcus

[toscanomatheus]

Hi Marcus,

I think you can accomplish that with the Group By node. You elect Name as a Group and ‘Concatenate’ or ‘Unique Concatenate’ as aggregation function.

Regards,
Matheus

[werwurm01]

Oh, shame on me
I didn’t check the parameter in “Group By” Node. With Unique Concentinate it works!

Thanks for the help and the fast reply.