cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Submit your abstract to the call for content for Discovery Summit Americas by April 23. Selected abstracts will be presented at Discovery Summit, Oct. 21- 24.
Discovery is online this week, April 16 and 18. Join us for these exciting interactive sessions.
Choose Language Hide Translation Bar
robot
Level VI

Set Column Values

I am creating several data tables, where I will add a Character column with repeating values.  I am using the repeat function to do this.  My trouble is that it seems to take a very long time for large repeat values.  Is there a more efficient way to do this?  I am using JMP11.  Thanks!

// Example.

Names Default To Here( 1 );

t1 = Tick Seconds();

dt = New Table( "50000 Rows", Add Rows( 50000 ),

      New Column( "Hello!", Character, Nominal, Set Values( Repeat( {"Hi!"}, 50000 ) ) )

);

t2 = Tick Seconds();

Print( Concat( Char( t2 - t1 ), " seconds." ) );

1 ACCEPTED SOLUTION

Accepted Solutions
ms
Super User (Alumni) ms
Super User (Alumni)

Re: Set Column Values

Set Each Value() should be a little more efficient:

New Column( "Hello!", Character, Nominal, Set each value("Hi!") )

View solution in original post

2 REPLIES 2
ms
Super User (Alumni) ms
Super User (Alumni)

Re: Set Column Values

Set Each Value() should be a little more efficient:

New Column( "Hello!", Character, Nominal, Set each value("Hi!") )

robot
Level VI

Re: Set Column Values

Thanks MS!