Share your ideas for the JMP Scripting Unsession at Discovery Summit by September 17th. We hope to see you there!
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
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

 

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.