215064_en-US

liliconcom

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=""></SET>

Thanks!

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",
 Add Rows ( 10 ),
 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]
);