topic Re: set value to selected cells in Discussions

set value to selected cells

Kevin — Wed, 11 Jul 2018 20:00:10 GMT

Hello,

I am trying to select certain cells in data table and set value 2 to them, but it doesn't work. Can someone check my script to see what's wrong with it?

sdt << selectwhere(
	:Informat( "06/26/2018 16:49:00", "m/d/y h:m:s" ) <= :Time <= :Informat(
		"06/26/2018 16:54:00",
		"m/d/y h:m:s"
	)
);
selRows = sdt << getselectedRows;
As Column( sdt, "Status" )[selRows] = "2";

Re: set value to selected cells

mikedriscoll — Wed, 11 Jul 2018 19:45:35 GMT

I don't have data to run your scritpt on but I changed it around for my data and it worked ok (but I didn't use the informat() function). Then I noticed you have a colon ":" before informat(), and the jsl editor does not show the hover text help for informat with the colon, but it does show it when I remove those colons. Try removing the two colons before the informat() and see if that helps. The colon ~~is used to define a column variable.~~ with syntax ":name" forces name to be evaluated as a data table column. (edited to give a more accurate description, from JMP's website)

BTW thanks for the tip on the logic structure there. I had no idea I could do a x < y < z in one quick swoop. Usually it's x < y & y < z.

Re: set value to selected cells

pmroz — Wed, 11 Jul 2018 20:16:26 GMT

If you use get rows where you can make sure that there are rows needing to be changed. As mentioned remove the leading colon from Informat. Change As Column to Column.

selrows = sdt << get rows where(
	Informat( "06/26/2018 16:49:00", "m/d/y h:m:s" ) <= :Time <= :Informat(
		"06/26/2018 16:54:00",
		"m/d/y h:m:s"
	)
);
if (nrows(selrows) > 0,
	Column( sdt, "Status" )[selRows] = "2";
);

Re: set value to selected cells

cwillden — Wed, 11 Jul 2018 20:16:28 GMT

First, remove the colon before Informat(). That is telling JMP that Informat is a column name. Start by taking those colons out. You can also simplify your script like so:

sel rows = sdt << Get Rows Where(Informat("06/26/2018 16:49:00", "m/d/y h:m:s") <= :Time <= Informat("06/26/2018 16:54:00", "m/d/y h:m:s"));
sdt:Status[selRows]="2";

You also need to verify that Status is character column. If it's numeric (even if the modeling type is nominal or ordinal), you need to remove the quotes around "2".

Re: set value to selected cells

Kevin — Thu, 12 Jul 2018 00:27:48 GMT

What's the difference of having if function here:

if (nrows(selrows) > 0,
	Column( sdt, "Status" )[selRows] = "2";
);

Also, what's the difference between ascolumn and column?

Just try to understand the script

Re: set value to selected cells

pmroz — Thu, 12 Jul 2018 13:34:06 GMT

The if function insures that you only try to set Status values to 2 if there were any matches.

I'm not sure about the difference between Column and As Column. Generally I just use Column. If that doesn't work I try As Column. :)

Re: set value to selected cells

Kevin — Thu, 12 Jul 2018 17:54:17 GMT

It works, Thank you!