data tables: get non-excluded rows (💚)

[hogi]

☐ 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  

[Sarah-Sylvestre]

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

[hogi]

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]

@Sarah-Sylvestre , thanks for delivering :)