Creating pivot table with drill down feature similar to excel in KNIME.

I’m new to KNIME and I’m trying to redo the tasks in KNIME which I used to do in excel. My question is that how to create a pivot table similar to excel, where you can have expanded rows and you can drill down to categories? I have created a simple pivot table using pivot node but I need to drill down from top level summary to bottom like we do in excel. Is it possible in KNIME?

Hi @umara,
That is not possible in KNIME like that. Drilling down is a pretty interactive activity, but the goal of KNIME is to make operations on tables reproducible, so they can run again and again on different input data. So in KNIME’s case, drilling down would be changing the configuration of the Pivot node to your liking and inspecting the output, but that is not really how it is meant to be used.
Kind regards,
Alexander

2 Likes

Hi @AlexanderFillbrunn
Thank you so much for your response. I will try working around the pivot node then.

Many thanks!
Umara

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