topic How to assign a list of values to specific list of rows (without for loop) in Discussions

How to assign a list of values to specific list of rows (without for loop)

Djtjhin — Fri, 09 Jun 2023 18:04:09 GMT

Is there a way to assign a list of values to specific rows in a column without for loop ?

For instance, is it possible to assign the "new values" in the script below to row 1,5,7 on the Weight column ?

The script below doesn't work. I know one of the way to do this is to use for loop, but I wonder if there are other methods without for loops.

dt = Open( "$SAMPLE_DATA/Big Class.jmp" );

index = [1,5,7];
new values = [11,22,33];
dt:weight[index] = new values;

jthi — Sat, 30 Oct 2021 09:35:12 GMT

No need to loop. This should work:

Names Default To Here(1);

dt = Open("$SAMPLE_DATA/Big Class.jmp");

index = [1, 5, 7];
new values = [11, 22, 33];
dt[index, "weight"] = new values;

Djtjhin — Mon, 01 Nov 2021 06:37:43 GMT

Fantastic @jthi !! Learn something new today :)