186051_en-US

liliconcom

Selection and coloring cells

So if I use:

dt = currentDataTable();
dt << select where(:RESULTNAME != "Success");
dt:RESULTNAME << color cells(RGB Color( 255, 150, 150 ));
dt << clear select();

 

When the data table has only 'Success' all cells are colored.  If the table has 1 value that is not 'Success' then it colors that cell and only that cell.  Anyway to have it not color all the cells when it only has 'Success'

Re: Selection and coloring cells

You can also use get rows where:

dt = currentDataTable();
match_rows = dt << get rows where(:RESULTNAME != "Success");
dt:RESULTNAME << color cells(RGB Color( 255, 150, 150 ), match_rows);

Re: Selection and coloring cellsThanks again!Re: Selection and coloring cells

Try using this method

names default to here(1);
dt=open("$SAMPLE_DATA/big class.jmp");
dt<<SELECT where=""></SELECT>