Create a table with pivoting node

[Stol]

Hello everyone,

is it possible to create a table like the example attached using the pivoting node?

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.

[Martyna]

Hi @Stol,

I don’t see any reason why this shouldn’t be possible
Important here would probably be to transform columns with type “Term” into String using the Term to String node. It might be the Pivot node would not work with column type Term.
If you are looking for examples how to setup the Pivot node, please check this example workflow here: https://kni.me/w/6OPrrabTBNBanSd5
or maybe the first three videos from this list might help a bit: https://www.youtube.com/results?search_query=pivot+knime

Also, it would be important to learn how your input table looks like.

Best,
Martyna

[Stol]

Thanks @Martyna!

I am still beginner in using KNIME. I already know how a pivot table is built up but my problem is that I don’t know how and especially where I can “position” the terms (they are converted to strings ) “at the top of the table”. Is it in the group settings or in the pivot settings?

[Martyna]

Could you maybe share a little example workflow with dummy data that I could use to play with? It is difficult to guess what might help without having a real example in place

[Martyna]

Hi, the workflow is not executed and contains therefore no data, so I am not able to see how it looks like. Could you please save it executed? of course only if you are fine if people see the data. Otherwise we should create a dummy example that only looks like your data set just by using the table creator node and adding some data in it.

[Stol]

Hello @Martyna,
I am very sorry for that. Now, I saved it executed: example.knwf (105.5 KB)
Let me know if you can now work with it

[Stol]

Hello,
any solutions or hints so far?

[ipazin]

Hi there @Stol,

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

Search Terms with dictionary tagger

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

[ipazin]

Hi @Stol,

I assume marking reply as Solution means yes

Tnx!

Br,
Ivan