topic Re: How to multiple select values from one column and subset them? in Discussions

How to multiple select values from one column and subset them?

frankzhao — Tue, 14 Oct 2014 02:12:09 GMT

I have a table which include a column named 'PCO',

In this column,there are lots of different values,such as 'PCO1','PCO2',...............'PCON',

I want to select the rows include 'PCO1' or 'PCO2' or 'PCO3' and subset them,

but the situation is that I want to use a string that

strPCO=="PCO1","PCO2","PCO3", to select values

so I write a script like:

data_table = open (DATA_PATH)

PCO_CONDITION = {"PCO1","PCO2","PCO3"};

for (i=1,i<=n items(PCO_CONDITION),i++,

data_table<<select where (:PCO ==PCO_CONDITION)

);

dt=data_table<<subset (selected rows);

this script cant work,can anybody tell me how to deal with it?

Thanks guys

Re: How to multiple select values from one column and subset them?

frankzhao — Tue, 14 Oct 2014 02:20:40 GMT

In addition,I want make all rows include these 3 PCOs into a subset,but now my script can only select the last one.

Re: How to multiple select values from one column and subset them?

ms — Tue, 14 Oct 2014 09:02:58 GMT

Use Or(), or here even better, Contains() to match any of the three conditions instead of one at a time.

Example:

//Example table

data_table = newtable("test", newcolumn("PCO", character,

values(Repeat(i=0;{i++ ; "PCO" || Char( Mod( i-1 , 5 )+1 )}, 25 )))

);

// Make conditional subset

PCO_CONDITION = {"PCO1","PCO2","PCO3"};

data_table<<select where(Contains(PCO_CONDITION,:PCO));

dt=data_table<<subset (selected rows);

Re: How to multiple select values from one column and subset them?

frankzhao — Tue, 18 Oct 2016 21:51:24 GMT

Thanks,I have another trouble here,I have a txtbox like this :

now my script is :

Panel Box ("PCO",

lineup box (N col( 1 ),Spacing ( 3 ),

//PCOcheck = check box({"Type in PCO"},PCO << enable (PCOcheck << Get ())),

PCO = text edit box("", << enable ( 1 ),

<<set script( txtPCO = PCO << Get Text();

),<< set width (240),<<set N lines(5)),

But how can I get a string like ("PCO1","PCO2","PCO3") from input?

Re: How to multiple select values from one column and subset them?

pmroz — Wed, 15 Oct 2014 12:37:12 GMT

You have to parse them out of the text edit box using words and a carriage return + line feed delimiter:

nw = New Window( "Example",

Panel Box( "PCO",

Lineup Box( N Col( 1 ), Spacing( 3 ),

pco_teb = Text Edit Box( "",

<<set width( 240 ),

<<set N lines( 5 )

)

button box("OK",

pco_text = pco_teb << get text;

// Create a delimiter consisting of a carriage return + line feed

crlf = hex to char("0D0A");

// Parse the list into separate words

pco_list = words(pco_text, crlf);

nW << close window;

);

Re: How to multiple select values from one column and subset them?

frankzhao — Thu, 16 Oct 2014 01:54:46 GMT

Thank you