How to merge multiple columns to one column in a table

KNIME Analytics Platform
1

Hi all,

I want to merge n columns (with row number m) into 1 column which will then result  into m*n rows and 1 column. 

I tried column aggregate, merge and concatenate nodes, but they simply work on row base. 

Thanks in advance.

Canan

1 Like
2

Try the column aggregator node using List as the aggregation type. 

Then use the UngroupBy node.

simon.

5 Likes
3

Hi Simon,

You solution perfectly worked. 

Thank you so much.

Regards,

Canan

4

I was thinking 'unpivot' but i guess Simon's way works too.

1 Like