How to set values for columns when adding rows?

PowerOx327 — Sat, 10 Jun 2023 23:52:02 GMT

Names Default To Here( 1 );
dt = Open( "$SAMPLE_DATA/Big Class.jmp" );
dt << Add Rows( 1, At End, {:name},{"Freddy"});

Hi,

I'm trying to add rows, and then set values for each column in the data table but it only adds a row without any values. What am I doing wrong in my script?

Re: How to set values for columns when adding rows?

jthi — Thu, 28 Jul 2022 06:31:38 GMT

I'm not 100% sure if you can set n or "location" when setting specific values, but values will get added to end by default (I think).

Below is example from Scripting Index. It will add new row with name colum set to "David" and age column set to 15.

Names Default To Here(1);
dt = Open("$SAMPLE_DATA/Big Class.jmp");
dt << Add Rows({name = "David", age = 15});

Also see this Scripting Guide > Data Tables > Rows > Add Rows

topic How to set values for columns when adding rows? in Discussions

How to set values for columns when adding rows?

Re: How to set values for columns when adding rows?