Pivot table like Excel

I want to have a pivot table in knime exactly like EXCEL. very simple PT, no need column… somehow i tried in KNIME. Column is a must… but i dont want Column. How should i do it

I also tried unpivot which is a disaster .

Try Group by node. Also, if you use database as a data source, you can use pivot table directly in Excel with DB as data source.

1 Like

Hello @TTMMLL,

Moved your question to new topic as it will get more attention and previous one was pretty old. Keep in mind that not all here are Excel users so give it a try with sharing input data and desired output to get more ideas/help/suggestions.

Welcome to KNIME Community!



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