Group by to Operate as Excel

izaychik63 · January 29, 2018, 9:46pm

In Excel Pivot table I can put same field in grouping category and aggregation.

Could it be possible in KNIME?

Currently for every case it is necessary to duplicate such columns.

Iris · February 1, 2018, 7:56am

Hi izaychik63,

no this is not possible in KNIME. Why do you want to do this?

If you already use it as a grouping column, the value is already retained in the output.

Cheers, Iris

izaychik63 · February 1, 2018, 6:59pm

Iris I want it because in Excel I can automatically generate list of possible values and count them in pivot table. This way I do not need to double 17 columns manually.