How to pass data from Select Where to array

[#1]

Hi, I'm trying to adapt this solution: https://community.jmp.com/t5/Discussions/Create-a-associative-array-from-unique-selected-rows-and-ro...

using Select Where instead of Select Rows.

dt1 << Select Where( :Test == "Fail" );

I would like to create an array of the columns Age and Class for all the selected rows. Selected Rows doesn't seem to work and the Script Index Guide isn't clear on what object Select Where returns.

Thank you

[#2]

Could you provide clear example about what you want to do? The linked topic doesn't seem to have Test, Age or Class mentioned anywhere. You want to select rows based on something and then get values based on that selection on some columns?

[#3]

Yes, so when I use:

dt1 << Select Where( :Test == "Fail" );

In the data table these rows appear as selected (highlighted in blue), the data table has columns Age and Class so I would like to create an array in pairs for all the selected rows. 

Then I want to use the array in pairs to hide and exclude all rows where Age and Class are equal to one of the pairs.

e.g. if one of the rows where Test = Fail has Age = 14 and Class = 2, I would want to store the values ( (14,2), ... , ) in an array and then all rows where Age = 14 and Class = 2  I want to hide and exclude.

[#4 · Accepted solution]

maybe something like this

dt = Open( "$sample_data/big class.jmp" );
rows = dt << getrowswhere( 13 <= age <= 15 );
matrix = dt[rows, {height, weight}];

I don't think <<SelectWhere returns a value; it makes rows in the table selected. Other messages, like <<deleteRows, can operate on the current selection.

[#5]

Thank you that works. I find the documentation quite difficult to navigate.