How to replace selected values in a column with JSLHi 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);<BR />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!
ScriptingRe: How to replace selected values in a column with JSL:Name("1")[ dt << get selected rows ] = 0;Re: How to replace selected values in a column with JSLThank 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 JSLdefine "combine the 2 columns"
Add them together?Re: How to replace selected values in a column with JSLBy 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 JSLdt << new column("Final Data", formula(:Area remaining water +
:area remaining exo));Re: How to replace selected values in a column with JSLThank you so much! Really helpful!Re: How to replace selected values in a column with JSLYou 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.
