How to merge multiple columns to one column in a table

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

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

Then use the UngroupBy node.

simon.

3 Likes

Hi Simon,

You solution perfectly worked. 

Thank you so much.

Regards,

Canan

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

1 Like