topic How to count number of rows generated by Tabulate()? in Discussions

How to count number of rows generated by Tabulate()?

Neo — Tue, 18 Jun 2024 11:21:58 GMT

I have a JSL of the form below to generate a table using Tabulate (). How do I count the number of rows in the table?

Note the number of rows change with what I have got selected in the Local Data Filter () and the row count needs to be updated with my filter selection.

Tabulate(
	Add Table(
		Column Table( Grouping Columns( :Parameter1 ) ),
		Row Table( Grouping Columns( :Wafer ) )
	),
	Local Data Filter(
		Conditional,
		Add Filter(
		
		// my filter selection goes here 
			
		)
	)
);

Re: How to count number of rows generated by Tabulate()?

hogi — Mon, 17 Jun 2024 14:20:32 GMT

you could use make into data table

Names Default To Here( 1 );
dt = Open( "$SAMPLE_DATA/Big Class.jmp" );

table = dt << Tabulate( Add Table( Row Table( Grouping Columns( :sex ) ) ) );
	

tabulateTable = table << Make Into Data Table;
count = N Rows( tabulateTable );
Close( tabulateTable, noSave );
count

Re: How to count number of rows generated by Tabulate()?

Neo — Tue, 18 Jun 2024 11:35:47 GMT

@hogi Thanks, but the count would not dynamically change when the data filter selection is changed, would it?

Re: How to count number of rows generated by Tabulate()?

hogi — Tue, 18 Jun 2024 11:52:19 GMT

You can add a button to the window - and click to calculate the rows.

Or automatically calculate the number, triggered by a state handler of the data filter.