Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 |
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.
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.