topic How to use JMP script to generate a table with duplicate data in Discussions

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

qspringleaf — Fri, 09 Jun 2023 23:33:32 GMT

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

kindly su

Before				After
Name	Shift				Name	Shift
John	ShiftA	------>'	John	ShiftA
Kevin	ShiftB				Kevin	ShiftB
Tom	ShiftC				Tom	ShiftC
Tim	ShiftD				Tim	ShiftD
Lily	ShiftE				Lily	ShiftE
Jessica	ShiftF				Jessica	ShiftF
					John	ShiftA
					Kevin	ShiftB
					Tom	ShiftC
					Tim	ShiftD
					Lily	ShiftE
					Jessica	ShiftF
					John	ShiftA
					Kevin	ShiftB
					Tom	ShiftC
					Tim	ShiftD
					Lily	ShiftE
					Jessica	ShiftF
					John	ShiftA
					Kevin	ShiftB
					Tom	ShiftC
					Tim	ShiftD
					Lily	ShiftE
					Jessica	ShiftF
					John	ShiftA
					Kevin	ShiftB
					Tom	ShiftC
					Tim	ShiftD
					Lily	ShiftE
					Jessica	ShiftF

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

tom_abramov — Tue, 28 Jul 2020 08:07:19 GMT

Try this:

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

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

Craige_Hales — Tue, 28 Jul 2020 10:11:59 GMT

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