cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • Image to Table JMP extension imports single or batch images as data tables. Useful to extract curves from pictures or convert image data to curve data to use in analyses like Functional Data Explorer. Download and install the extension.

Discussions

Solve problems, and share tips and tricks with other JMP users.
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

Recommended Articles