combine n rows as column

[thrichter]

I want to join every nth rows as column. Input:

colName

row1

row2

row3

row4

row5

row6

row7

Output:

rowCombi

row1;row2;row3

row4;row5;row6

row7

[thrichter · Accepted solution]

Add a column group with content: (int) (( Numeric.sequence("rowNumber",1,1) - 1) / 3)+1 and use tAggregateRow with group by column group and in operations use as function list.