https://community.jmp.com/t5/Discussions/Select-first-second-half-of-rows-to-form-a-subset/m-p/230663#M45742 <P>You can use the following JSL</P> <PRE><CODE class=" language-jsl">dt=current data table(); dt&lt;&lt;select where(Row()&lt;=N Rows(dt)/2); dt2=dt&lt;&lt;subset(selected rows(1), selected columns(0));</CODE></PRE> Thu, 24 Oct 2019 18:35:32 GMT txnelson 2019-10-24T18:35:32Z https://community.jmp.com/t5/Discussions/Select-first-second-half-of-rows-to-form-a-subset/m-p/230647#M45739 <P>I have a question about how to select first half or second of rows to form a subset. I don't want to manually type in 1,2,3,4,5,...,10 (if there are 20 rows) because my rows could be different from time to time. I have a equation that define number of rows that will appear in the original table. Is there anything like select row (1:10) or others that make it easier?</P> Thu, 24 Oct 2019 17:32:58 GMT https://community.jmp.com/t5/Discussions/Select-first-second-half-of-rows-to-form-a-subset/m-p/230647#M45739 aaronjiang 2019-10-24T17:32:58Z https://community.jmp.com/t5/Discussions/Select-first-second-half-of-rows-to-form-a-subset/m-p/230663#M45742 <P>You can use the following JSL</P> <PRE><CODE class=" language-jsl">dt=current data table(); dt&lt;&lt;select where(Row()&lt;=N Rows(dt)/2); dt2=dt&lt;&lt;subset(selected rows(1), selected columns(0));</CODE></PRE> Thu, 24 Oct 2019 18:35:32 GMT https://community.jmp.com/t5/Discussions/Select-first-second-half-of-rows-to-form-a-subset/m-p/230663#M45742 txnelson 2019-10-24T18:35:32Z