Hello everyone, is it possible to create a table like the example attached using the pivoting node? [Pivoting] I want do display the changes of the frequencies of the terms (~50) over 3 years. What do I have to select in the group and pivot settings? I would be very grateful if anyone has a hint for me.

Hi there @Stol , if I got it right you managed to find solution for your problem in this topic: [image] Search Terms with dictionary tagger KNIME Extensions Hey @Stol , your approach seems to be good so far. How do you know the year of the document/file? Do you have a dedicated year column? If this is the case, you can use the Year column and the Term as Strings column as pivots. Set the column name on the bottom of the configuration of the Pivoting node to Pivot+Aggregation column and check the Sort lexicographically box. The columns will then probably be sorted by year, so you might resort them afterwards, if you want to have them sorted by term … Br, Ivan

Create a table with pivoting node

KNIME Extensions

ipazin May 20, 2020, 12:56pm 9

Hi there @Stol,

if I got it right you managed to find solution for your problem in this topic:

Br,
Ivan