365610_en-US

liliconcom

How do I get Comma separated user input to subset rows with specific value?

Hi, I have a data table that contains information in the below format. I'd like to create a button on jmp that when clicked should prompt to enter a list of comma separated values from the user (possibly in a text box?) to subset just the rows with that value in a specific column.

For example in the text box if the user chooses BB,EE, then in the attached table (sample_table.jmp) only those rows will be subsetted out to form a new table.

 

How do I accomplish this using JSL? Thanks!

AnalyticsRe: How do I get Comma separated user input to subset rows with specific value?

Here is one of the many ways this can be done

names default to here( 1 );
dt = Current Data Table();
dt << clear select;

NW = New Window( "Select",
 V List Box(
  Text Box( "Input a comma separated list th the Names you want subsetted" ),
  teb = Text Edit Box( "", <<SET width=""></SET>

Re: How do I get Comma separated user input to subset rows with specific value?

Thanks Jim! That does it.