Pivot of data - aggregate by row function

KNIME Analytics Platform
1

Hi there,

Another stanage problem, how can I pivot a block of data in KNIME. For example,

Col1, Col2, Col3
1,123,12
1,123,23
1,123,25
1,324,34
1,324,23

So I need to transform this data into the following form;

Col1, Col2, Col3
'1','123', '12,23,25'
'1','324', '34,23'

What I am after is an aggregate by row function. Sorry forgot to add that col1, col2 are probably alphanumeric values.

Any ideas?

Stanage

2

Hi Stanage,
you can use the GroupBy node to perform the aggregation. Select col1 and col2 as group by columns and 'concatenate' or 'unique concatenate' as aggregation method.

Bye,
Tobias

3