How to use JMP script to generate a table with duplicate data

Question

How to use JMP script to generate a table with duplicate data, list below...

kindly su

Before   AfterNameShift   NameShiftJohnShiftA------>'JohnShiftAKevinShiftB   KevinShiftBTomShiftC   TomShiftCTimShiftD   TimShiftDLilyShiftE   LilyShiftEJessicaShiftF   JessicaShiftF     JohnShiftA     KevinShiftB     TomShiftC     TimShiftD     LilyShiftE     JessicaShiftF     JohnShiftA     KevinShiftB     TomShiftC     TimShiftD     LilyShiftE     JessicaShiftF     JohnShiftA     KevinShiftB     TomShiftC     TimShiftD     LilyShiftE     JessicaShiftF     JohnShiftA     KevinShiftB     TomShiftC     TimShiftD     LilyShiftE     JessicaShiftF

tom_abramov · Accepted Answer

Try this:

dt = Current Data Table();
Ntimes = 5;
for(i=1,i<=Ntimes,i++,
	dt << Concatenate (dt, Append to first table(1));
);

Craige_Hales · Accepted Answer

Nice! if you want N copies rather than doubling the size N times, you can start with an empty table like this:

dt = Current Data Table();
Ntimes = 5;
dtnew = New Table();
For( i = 1, i <= Ntimes, i++,
	dtnew << Concatenate( dt, Append to first table( 1 ) )
);

The empty table is special when first created: it appears to have a column named "Column 1", but that column is a placeholder that will vanish if not used.

Doubling with Tom's answer is much faster if you need a lot of copies. 10 doubles in 0.02 sec or 1024 copies in 0.50 sec.

@chungwei