JSL - Replacing Column Values with Vector

EDW — Fri, 28 Jun 2019 15:15:30 GMT

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!

Re: JSL - Replacing Column Values with Vector

txnelson — Thu, 27 Jun 2019 19:08:56 GMT

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]
);

topic Re: JSL - Replacing Column Values with Vector in Discussions

JSL - Replacing Column Values with Vector

Re: JSL - Replacing Column Values with Vector