topic Re: Repeat a sequence in a column -JSL in Discussions

Repeat a sequence in a column -JSL

vishwasanj — Wed, 25 Jan 2017 20:35:05 GMT

I was looking into the scripting guide, and it talks about Sequence( from, to, stepsize, repeat ); with from, to , stepsize and repeat.

What if I want 3 values say, 1, 50000, 100000 repeated till the end of table in a column? (This is basically highlighting the 3 values in a column and right click and say fill to the end of the table)

Do i have to run a for loop, or is there like a one line script available in JSL?

Thank you so much for your suggestions.

Re: Repeat a sequence in a column -JSL

Mark_Bailey — Wed, 25 Jan 2017 21:34:11 GMT

Notice that when you select Cols > New Column, there is an option near the bottom of the dialog to initialize the new column in several ways including a sequence. If you created the new column by double-clicking to the right of the last column, then select the new, empty column and select Cols > Column Info to see the same feature.

Note that this feature disappears as soon as you enter any values in the column another way.

No formula or script necessary for a simple case like this one. Already provdided for,

Re: Repeat a sequence in a column -JSL

David_Burnham — Thu, 26 Jan 2017 22:10:02 GMT

Here is some code to play with

lst = {1,50000,100000};
nRepeats = 10;
values = Repeat(lst,nRepeats); // this will be a list of 30 values
values[1::NRows(dt);
Column(dt,"Test") << Set Values(values);
// if the table only had 25 rows I could use values[1::25]

Re: Repeat a sequence in a column -JSL

PS_Ato — Wed, 27 Mar 2019 12:44:29 GMT

Hi Mark,

this was new for me - thank you. Could you please help me how to create a script? We import data regularily and always need to add columns with e.g. 10 repetitions each value (from 1 to 16).