topic Re: Getting the total row number in Discussions

Getting the total row number

GroupSquareWolf — Fri, 09 Jun 2023 18:13:58 GMT

This is probably very simple, but I could not find my answer in Scripting Index.

Trying to write a script to return the total number of rows into a variable, eg, if a data table has 100 rows, return the number 100; if it has 50, return the number 50.

Using JMP16.

Thank you for your help!

Re: Getting the total row number

Mark_Bailey — Tue, 22 Mar 2022 12:11:58 GMT

N Row() or N Rows() return this value for you. It returns the number of rows of the current data table by default. You can specify an argument that is a data table reference or a matrix and get specific data structure.

I recommend reading the Scripting Guide that is available in the JMP Help menu (documentation). There is also a browser for JSL through Help > Scripting Index.

Re: Getting the total row number

GroupSquareWolf — Wed, 23 Mar 2022 14:04:18 GMT

Thank you!