Posts

How-to-select-rows-that-match-any-value-in-a-list

 https://community.jmp.com/t5/JMP-Knowledge-Base/How-to-select-rows-that-match-any-value-in-a-list/ta-p/575348 /* 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 dt < < Clear Select ; // 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 ) ) ;