topic How to replace selected values in a column with JSL in Discussions

How to replace selected values in a column with JSL

ASullivan — Fri, 09 Jun 2023 22:02:56 GMT

Hi everyone,

I'm looking to replace alternate values in a column in using scripting. I've managed to select the values in the table but I'm struggling to find a way to replace them in just 1 column only.

This is my code so far:

Names Default To Here (1);
dt << new column ("selection", formula (sequence (1,2,1 )));

dt:selection << delete formula;
dt << select where(:1 & :selection !=1);

This is the table it creates:

I want to replace the values highlighted in the first column with 0. Any advice on how to accomplish this would be appreciated. Thanks!

Re: How to replace selected values in a column with JSL

txnelson — Tue, 12 Jan 2021 09:40:54 GMT

:Name("1")[ dt << get selected rows ] = 0;

Re: How to replace selected values in a column with JSL

ASullivan — Tue, 12 Jan 2021 10:51:47 GMT

Thank you @txnelson!

Also wondering if its possible to then combine the 2 columns into a new column and excluding the 0 values?

Re: How to replace selected values in a column with JSL

txnelson — Tue, 12 Jan 2021 11:11:22 GMT

define "combine the 2 columns"
Add them together?

Re: How to replace selected values in a column with JSL

ASullivan — Tue, 12 Jan 2021 11:51:15 GMT

By combine I mean have all the data in 1 column and disregard the 0 values, to end up with a table like this:

Re: How to replace selected values in a column with JSL

txnelson — Tue, 12 Jan 2021 14:10:10 GMT

dt << new column("Final Data", formula(:Area remaining water +
:area remaining exo));

Re: How to replace selected values in a column with JSL

ASullivan — Tue, 12 Jan 2021 14:57:33 GMT

Thank you so much! Really helpful!

Re: How to replace selected values in a column with JSL

txnelson — Tue, 12 Jan 2021 16:13:11 GMT

You need to do some reading. The Discovering JMP and the Using JMP documents. They are found in the JMP Documentation Library under the Help pull down menu.