cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Choose Language Hide Translation Bar
0 Kudos

data tables: get non-excluded rows

☐ cool new feature
☐ could help many users!

☐ removes a „bug“

☑ nice to have

☐ nobody needs it

 

 

Please allow the user to send

 

 

 

 

 

 

 

 

dt << Get nonExcluded Rows();

 

 

 

 

 

 

 

 

to a data table to get a matrix of all row numbers of non-excluded rows. 
Please make the implementation as fast as

dt << Get Excluded Rows();

https://community.jmp.com/t5/Discussions/col-lt-lt-get-values-for-non-excluded-rows/m-p/556579/highl... 

 

The fastes single-line command that was posted in the community is almost an order of magnitude slower:

 

 

 

 

 

 

 

 

allRows = dt << get rows where( Excluded() == 0 );

 

 

 

 

 

 

 

 

https://community.jmp.com/t5/Discussions/col-lt-lt-get-values-for-non-excluded-rows/m-p/564380/highl... 

 

And first asking for the non-excluded rows and then "inverting the list" adds 30-50% to the time budget.

https://community.jmp.com/t5/Discussions/col-lt-lt-get-values-for-non-excluded-rows/m-p/564136/highl... 

 

more wishes submitted by  hogi_2-1702196401638.png

6 Comments
Status changed to: Acknowledged

Hi @hogi, thank you for your suggestion! We have captured your request and will take it under consideration.

mia_stephens
Staff
Status changed to: Investigating
 
mia_stephens
Staff
Status changed to: Yes, Stay Tuned!
 
hogi
Level XII

Post by  @Audrey_Shull in Discussions:

https://community.jmp.com/t5/Discussions/col-lt-lt-get-values-for-non-excluded-rows/m-p/619448/highl... 

@Audrey_Shull wrote:

Thank you for the suggestions. JMP 18 will implement a new series of JSL functions that improves the performance and readability of the specific query discussed here and other similar queries. Documentation has been updated also to reflect the preferred/faster methods. 

The JSL looks something like this:

//instead of Get Rows Where()
Where( dt, Excluded() );
Where( dt, !Excluded() );
Where( dt, Hidden() );
Where( dt, !Hidden() );
Where( dt, Labeled() ); 
Where( dt, !Labeled() );
Where( dt, Is Missing() );

 

hogi
Level XII

@Sarah-Sylvestre , thanks for delivering

Status changed to: Delivered