Re: data tables: get non-excluded rows - Status changed to: AcknowledgedHi @hogi, thank you for your suggestion! We have captured your request and will take it under consideration.
Re: data tables: get non-excluded rows - Status changed to: InvestigatingRe: data tables: get non-excluded rows - Status changed to: Yes, Stay Tuned!Re: data tables: get non-excluded rowsPost by @Audrey_Shull in Discussions:
https://community.jmp.com/t5/Discussions/col-lt-lt-get-values-for-non-excluded-rows/m-p/619448/highlight/true#M81887
@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() );
data tables: get non-excluded rows (:green_heart:)☐ 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/highlight/true#M77051
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/highlight/true#M77688
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/highlight/true#M77669
more wishes submitted by 
Automation and ScriptingRe: data tables: get non-excluded rows@Sarah-Sylvestre , thanks for delivering 
Re: data tables: get non-excluded rows - Status changed to: Delivered
