46411_en-US

liliconcom

Select rows that match any value in a list

Problem

Suppose you prompt a user to make a selection. When you retrieve the values from the user, typically they are stored in a list.  Now you need to select the data that matches the values in the list.

Solution

The following example demonstrates how you can select rows in a data table that contain any value stored in a JSL list. Lists containing either numeric values or character strings can be used and are shown below.  See the embedded comments for details.

/* Open a sample data table. */
dt = Open( "$SAMPLE_DATA\Big Class.jmp" );

/* Create a list of ages. */
myList = {9, 12, 15, 17, 18};

/* Select all rows which have an age that is in the list. */
dt << Select Where( Contains( myList, :age ) );

Wait( 2 );           // For demonstration purposes

/* Create a list of student names. */
myStudents = {"HENRY", "ROBERT", "BARBARA", "SALLY", "MARION"};

/* Select all rows which have any of the names in the list. */
dt << Select Where( Contains( myStudents, :name ) );

Discussion

In these examples, the Contains() function is used to compare each row to the list of values.

Many more examples of using Select Where() can be found in the Select Rows section of the JMP Scripting Guide.

See Also

Select rows from the currently selected rows

Select rows based upon multiple conditions

Re: Select rows that match any value in a list

Ah, nice

I feared that contains is slower. but actually ...
note to myself: use contains 

 

 

View more...

 

Re: Select rows that match any value in a list

Is there some specific need to use more complex syntax? You could use Loc with Any

Names Default To Here(1);

dt = Open("$SAMPLE_DATA\Big Class.jmp");
dt << Select Where(Any(Loc({"JANE", "DAVID", "PATTY"}, :name)));

 

Re: Select rows that match any value in a list

same result, yes.
but different syntax.

Re: Select rows that match any value in a list

Isn't that what you would use Contains() for?

Re: Select rows that match any value in a list

dt << Select Where( Any( Row() == Index( 3, 5 ) ) );

is cool

 

is there something similar for

dt << Select Where( Any( :name == {"JANE", "DAVID","PATTY"}) );

?