Set Column Values

robot — Wed, 29 Jul 2015 00:01:16 GMT

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

Re: Set Column Values

ms — Wed, 29 Jul 2015 07:29:10 GMT

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

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

Re: Set Column Values

robot — Wed, 29 Jul 2015 17:18:42 GMT

Thanks MS!

topic Re: Set Column Values in Discussions

Set Column Values

Re: Set Column Values

Re: Set Column Values