527464_en-US

liliconcom

How to add repeating character values to column?

Hi, 

I'm looking to create a column and populate it with a list of character and numeric values - [ Min, Max, 0.5, 0.6,.....,1], and this list repeated 50 times. I usually copy paste these into a column (as shown below), but I'm wondering if there's a way do it using JSL ( using JMP14). 

 

Thanks.

Data TableScriptingRe: How to add repeating character values to column?

Using Repeat() with the list you want to repeat should work. Quick example (tested with JMP16):

Names Default To Here(1);


list_to_repeat = {"MIN", "MAX", "0.5", "1", "2"};
list_to_col = Repeat(list_to_repeat, 5);

dt = New Table("",
 New Column("Column 1", Character, Nominal, Values(list_to_col))
);