Problem with Grouping items

[seif]

Hello,

It's my first post.

I have a workflow to extract topics from some abstracts. After doing pre-processing and extracting topics, I want to group my documents by assigned topics (There are more than one topic for some articles, but I don't know if it's correct or not to have more than one topic for documents!). Now I use Group By node and I struggled with all possible setting but the results is always like below:

RowID   Document   Topic

1             doc1           3

2             doc1           3

3            doc1             8

....

 

How can I assign all topics to doc1 to have:

doc1    [3,8]

 

thanks

[tobias.koetter]

Hello,

if you group by the document column and use either the unique concatenate or the set method as aggregation method for the topic column you will end up with the result you explain.

Bye

Tobias