cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
JMP is taking Discovery online, April 16 and 18. Register today and join us for interactive sessions featuring popular presentation topics, networking, and discussions with the experts.
Choose Language Hide Translation Bar
yves38
Level II

Assign values to selected rows

Hi,

I want to assign a value in a column for a set of rows selected.

I select the rows like this:

 

dt=current data tables();
dt << selectwhere(dt:columnA == "1" );

 

And I would like to assign the value "TEST" to the columnC for all the selected rows (only for the selected rows).

How can I do it very simply (i.e. without for loop)?

Thanks in advance.

1 ACCEPTED SOLUTION

Accepted Solutions
ian_jmp
Staff

Re: Assign values to selected rows

It might be better to use '<<getRowsWhere()':

 

NamesDefaultToHere(1);
dt = Open("$SAMPLE_DATA/Big Class.jmp");
Wait(3);
r = dt << getRowsWhere(:height < 55);
Column(dt, "weight")[r] = .;

 

And for JMP 13, see also:

 

https://community.jmp.com/t5/Uncharted/Data-table-subscripting/ba-p/21013

 

View solution in original post

2 REPLIES 2
ian_jmp
Staff

Re: Assign values to selected rows

It might be better to use '<<getRowsWhere()':

 

NamesDefaultToHere(1);
dt = Open("$SAMPLE_DATA/Big Class.jmp");
Wait(3);
r = dt << getRowsWhere(:height < 55);
Column(dt, "weight")[r] = .;

 

And for JMP 13, see also:

 

https://community.jmp.com/t5/Uncharted/Data-table-subscripting/ba-p/21013

 

yves38
Level II

Re: Assign values to selected rows

Excellent !

Thank  you.