I have data table with 6 col & 10,000 rows. Col (1st, 2nd, 3rd) are random number. Meanwhile col (4th, 5th, 6th) are tabulate based on the random number in col (1st, 2nd, 3rd). oHow do i cut all 10,000 row data in col (4th, 5th, 6th) and paste into rows 10,001 of col (1st, 2nd 3rd) without copying the formula? Here is my script but it doesn't work: dt_temp = New Table ( "Temp", Add rows( 10000 ), New Column( "Build", character, nominal, formula( "L1" ) , New Column( "L1u", random, formula( Random Normal(a,b) ), New Column( "L1v", random, formula( Random Normal(c,d) ) , New Column( "Build2", character, nominal, formula( "L2" ) ), New Column( "L2u", numeric, continuous, formula( :L1u *123 + :L1v*345) ), New Column( "L2v", numeric, continuous, formula( :L12 *223 + :L1v*562) )); Current Data Table() << Subset( Columns( Column( 1 ), Column( 2 ), Column( 3 ), Column( 4 ), Column( 5 ), Column( 6 ) ), Copy formula( 0 ) ); Current Data Table () << Add rows(10000); ?? C1_list = Column(1) << Get Values; ?? C4_list = Column(4) << Get Values; ?? Column(1) << Insert Into( Insert (C1_list, C4_list, 100001)) ; ?? C2_list = Column(1) << Get Values; ?? C5_list = Column(5) << Get Values; ?? Column(2) << Insert Into( Insert (C2_list, C5_list, 100001)) ; ?? C3_list = Column(1) << Get Values; ?? C6_list = Column(5) << Get Values; ?? Column(3) << Insert Into( Insert (C3_list, C6_list, 100001)) ; Current Data Table () << delete columns (column(4),column(5); column(6);
... View more