topic How to add repeating character values to column? in Discussions

How to add repeating character values to column?

D_T_M — Sat, 10 Jun 2023 23:52:04 GMT

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.

Re: How to add repeating character values to column?

jthi — Thu, 28 Jul 2022 11:00:50 GMT

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