Keywords Occurencies

KNIME Analytics Platform
1

Hi,

I've a table with two columns: Author, Keywords.

My goal is to obtain the first 5 keywords most used by a single author, the column Keywords can be a list of the various keywords (with also repetition) or a simple String which has a coma as a separator.

How can I do it? There is any particular node or I have to create a Java Snippet?

I've tried with a node GroupBy trying to use in the options "Unique concatenate with count" as aggregation but it doesn't split by single words. 

2

Hi,

attached you can find an example flow that extracts the top k keywords per author using the GroupBy and Group Loop Start node.

Bye,

Tobias

3

Thanks!

Bye, 
Samuele