It’s World Statistics Day! To honor the theme of the day, the JMP User Community is having conversations about the importance of trust in statistics and data. And we want to hear from you! Tell us the steps you take to ensure that your data is trustworthy.
Choose Language Hide Translation Bar
Highlighted
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
Highlighted
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
Highlighted
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

Highlighted
yves38
Level II

Re: Assign values to selected rows

Excellent !

Thank  you.

Article Labels

    There are no labels assigned to this post.