Hi Everyone,
I need a support to prepare a report like pivot table. I tried using pivoting node. But I couldn’t set the node properly. Can anyone provide me any suitable solution?
I added calculation column in Manual Aggregation tab. But I am a bit confused what I have to provide in pivots and groups.
Items: A,B,C,D,E
Decision: yes, no
possibility: High, medium and low
First of all, I need to count and display decision and possibility column separately for 5 items. After that, I need to calculate sum of each column along with grand total (15 for decision and 15 for possibility)
I have attached demo data along with required table.
As @izaychik63 said, the Pivoting node requires you to have a column on which to pivot, and another on which to aggregate. In your case, you’ll need to add another column.
Or you could use 2 separate pivots:
in the first, group by Items, pivot on Decision, and aggregate on Possibility using Count
in the second, group by Items, pivot on Possibility, and aggregate on Decision using Count
Then, join the outputs of both pivoting nodes to get a single table.
If you want column totals, then you can concatenate the first and third outputs of each pivoting node to attach the column totals, before doing the join.
Concatenating a row of grand totals is left for you to work on.
Your desired output table is formatted to be a human-readable spreadsheet. You might be able to approximate it in a KNIME table, but this isn’t really what KNIME is for.