cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Check out the JMP® Marketplace featured Capability Explorer add-in
Choose Language Hide Translation Bar
D_T_M
Level II

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). 

D_T_M_0-1658993043828.png

 

Thanks.

1 ACCEPTED SOLUTION

Accepted Solutions
jthi
Super User

Re: 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))
);
-Jarmo

View solution in original post

1 REPLY 1
jthi
Super User

Re: 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))
);
-Jarmo