How to replace selected values in a column with JSL

[#1]

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! 

[#2 · Accepted solution]

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

[#3]

Thank you @txnelson! 

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

[#4]

define "combine the 2 columns"
Add them together?

[#5]

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

[#6]

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

[#7]

Thank you so much! Really helpful!

[#8]

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.