https://community.qlik.com/t5/Talend-Studio/combine-n-rows-as-column/m-p/2457818#M140715 <P>Add a column <FONT face="courier new,courier">group</FONT> with content:&nbsp;<CODE>(int) (( Numeric.sequence("rowNumber",1,1) - 1) / <FONT color="#0000FF"><U><STRONG>3</STRONG></U></FONT>)+1 </CODE> and use&nbsp;<FONT face="courier new,courier">tAggregateRow</FONT> with group by column <FONT face="courier new,courier">group</FONT> and in operations use as function <FONT face="courier new,courier">list</FONT>.</P> Thu, 30 May 2024 11:41:41 GMT thrichter 2024-05-30T11:41:41Z https://community.qlik.com/t5/Talend-Studio/combine-n-rows-as-column/m-p/2457802#M140714 <P>I want to join&nbsp;every nth rows as column. Input:</P> <TABLE border="1" width="97.96748463700457%"> <TBODY> <TR> <TD width="100%" height="24px">colName</TD> </TR> <TR> <TD width="100%" height="24px">row1</TD> </TR> <TR> <TD width="100%" height="24px">row2</TD> </TR> <TR> <TD width="100%" height="24px">row3</TD> </TR> <TR> <TD width="100%" height="24px">row4</TD> </TR> <TR> <TD width="100%" height="24px">row5</TD> </TR> <TR> <TD width="100%" height="24px">row6</TD> </TR> <TR> <TD height="24px">row7</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>Output:</P> <TABLE border="1" width="100%"> <TBODY> <TR> <TD width="100%">rowCombi</TD> </TR> <TR> <TD width="100%">row1;row2;row3</TD> </TR> <TR> <TD width="100%">row4;row5;row6</TD> </TR> <TR> <TD width="100%">row7</TD> </TR> </TBODY> </TABLE> Thu, 30 May 2024 11:43:48 GMT https://community.qlik.com/t5/Talend-Studio/combine-n-rows-as-column/m-p/2457802#M140714 thrichter 2024-05-30T11:43:48Z https://community.qlik.com/t5/Talend-Studio/combine-n-rows-as-column/m-p/2457818#M140715 <P>Add a column <FONT face="courier new,courier">group</FONT> with content:&nbsp;<CODE>(int) (( Numeric.sequence("rowNumber",1,1) - 1) / <FONT color="#0000FF"><U><STRONG>3</STRONG></U></FONT>)+1 </CODE> and use&nbsp;<FONT face="courier new,courier">tAggregateRow</FONT> with group by column <FONT face="courier new,courier">group</FONT> and in operations use as function <FONT face="courier new,courier">list</FONT>.</P> Thu, 30 May 2024 11:41:41 GMT https://community.qlik.com/t5/Talend-Studio/combine-n-rows-as-column/m-p/2457818#M140715 thrichter 2024-05-30T11:41:41Z