cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Discussions

Solve problems, and share tips and tricks with other JMP users.
Choose Language Hide Translation Bar
lala
Level IX

It's unexpected that the file merging speed of JMP Pro 14 is so much faster than that of JMP Pro 18

The speed of file splicing has slowed down since JMP Pro 18
I had to use JMP Pro14 again to operate.

dir="C:\0\";;Fs=Files In Directory(dir);
for(j=1,j<=N Items(fs),j++,
d1=Open(dir||fs[j],Add to Recent Files(0));na=d1<<Get Name();
if(j==1,d2=d1;d2<<setName("名2");,current data table(d2);d2<<Concatenate(Data Table(d1),Append to first table);Close(d1,nosave));
);
try(d2<<Delete Table Property("Source"));d2<<Save("D:\0\JMP\big.jmp");
1 REPLY 1

Re: It's unexpected that the file merging speed of JMP Pro 14 is so much faster than that of JMP Pro 18

Hello Lala,

Have you tried putting Begin Data Update and End Data Update around the outside of your for loop? This example below is from the Scripting Index.

Brian Corcoran

JMP Development

dt << Begin Data Update;
dt << Add Rows( 2000 );
dt << End Data Update;

Recommended Articles