Choose Language Hide Translation Bar
Highlighted
Level I

## JSL - Replacing Column Values with Vector

I'm attempting to script a function that replaces a range of column values with a vector of equal dimension. My code below either rejects the argument entirely or just changes the entire cell value to the vector, rather than spanning the range. I can imagine creating a "for loop" that would iterate through each row and and index the vector accordingly, but writing one value at a time seems inefficient, especially since my actual spreadsheet has about 100k rows. Here is a simple example of my process:

``````Names Default To Here( 1 );

//Example Table
dt = New Table( "Example", Add Rows( 10 ), New Column( "Test", <<Set Each Value( 1 ) ) );

Wait( 1 ); //Demonstration Purposes

x = [10, 10, 10];
:Test[3 :: 5] = x;``````

Thanks!

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User

## Re: JSL - Replacing Column Values with Vector

Here is an old school way to do this:

``````Names Default To Here( 1 );

//Example Table
dt = New Table ("Example",
New Column ( "Test", << Set Each Value ( 1 ) );
);

Wait (1); //Demonstration Purposes

x = [10, 10, 10];
start=3;
for(i=1,i<=nrows(x),i++,
:test[i+start-1]=x[i]
);``````
Jim
Highlighted
Super User

## Re: JSL - Replacing Column Values with Vector

Here is an old school way to do this:

``````Names Default To Here( 1 );

//Example Table
dt = New Table ("Example",
New Column ( "Test", << Set Each Value ( 1 ) );
);

Wait (1); //Demonstration Purposes

x = [10, 10, 10];
start=3;
for(i=1,i<=nrows(x),i++,
:test[i+start-1]=x[i]
);``````
Jim
Article Labels

There are no labels assigned to this post.