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.
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
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
Excellent !
Thank you.