Concatenating column values


I’ve got a table from the the Topic Extractor (paralled LDA) node:

Term Topic id

a          topic_0

b          topic_0

c          topic_1

d          topic_1

e          topic_1

I'd like to have a table like this:

Topic id           Term list

topic_0           a, b

topic_1           c, d, e

Any suggestion is welcome.



Try the GroupBy node, grouping on the "Topic id" column with "List" as aggregation function on the "Term" column.

Thank you very much, Thor!

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