Creating a collection by grouping values

KNIME Analytics Platform
#1

Hi,

I have a table like

Txn# ItemID
1 101
1 102
2 103
2 104
3 101
3 102
3 103
I want output like
Txn# ItemSet
1 [101,102]
2 [103,104]
3 [101,102,103]

Can anyone please guide.

Thanks
Sud

#2

Hi @sud

Take a look at the GroupBy node. There you can aggregate on ItemID and create a list / item set.
Screenshot from 2020-03-05 11-23-17

3 Likes
#3

Thank you so much. It worked.

image

2 Likes
#4

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.