cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Choose Language Hide Translation Bar
Neo
Neo
Level VI

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

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 
			
		)
	)
);

 

 

When it's too good to be true, it's neither
3 REPLIES 3
hogi
Level XI

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

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
Neo
Neo
Level VI

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

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

When it's too good to be true, it's neither
hogi
Level XI

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

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.