topic Re: How to pass data from Select Where to array in Discussions

How to pass data from Select Where to array

Agustin — Fri, 09 Jun 2023 17:00:49 GMT

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

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

Re: How to pass data from Select Where to array

jthi — Thu, 09 Jun 2022 13:54:32 GMT

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?

Re: How to pass data from Select Where to array

Agustin — Thu, 09 Jun 2022 14:12:22 GMT

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.

Re: How to pass data from Select Where to array

Craige_Hales — Thu, 09 Jun 2022 14:15:11 GMT

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.

Re: How to pass data from Select Where to array

Agustin — Thu, 09 Jun 2022 14:19:33 GMT

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