Does JMP have a hidden cache for opened file names? Can I clean it? Is this a bug?

saitcopuroglu

I have a beginning part of a long script as:

);

Data Table( "AgencyStayISL.jmp" ) << Concatenate(

    Data Table( "AgencyStayLBL.jmp" ),

    Output Table( "AgencyStay" ),

    Keep Formulas,

    Create source column

);

When I first time open and run JMP everything is fine. When I close all windows and rerun the script the output table name turns to "AgencyStay 2" instead of "AgencyStay" which kills the rest of the process hence the whole depends on the output table name. When I quit JMP reopen and rerun then everything is again fine which means I have to quit and reopen JMP 80 times a day. Is there a hidden cache for opened file names? If so how can I always keep it unrecorded? Or is this a bug?

Would appreciate any help

Craige_Hales

This works for me, in JMP 11.  If you force the AgencyStay table to already exist, the Try( close( ... ) ... ) at the beginning will clean it up and tell you what happened.

In my example, I assign the new table to c so I can have a reference to the table that was created, and even ask it what name it actually received if JMP had to resolve a name collision with an existing table.

// this is only needed if the previous script failed to close the table
Try(
  Close( Data Table( "AgencyStay" ), "nosave" );
  Print( "found one!" );
,
  Print( "good start" )
);
// this loop tests, 10 times, that the name does not change
For( i = 1, i < 10, i++,
  a = Open( "$desktop/a.jmp" );
  b = Open( "$desktop/b.jmp" );
  c = Data Table( "a.jmp" ) << Concatenate(
  Data Table( "b.jmp" ),
  Output Table( "AgencyStay" ),
  Keep Formulas,
  Create source column
  );
  Print( c << getname() );
  Close( a, "nosave" );
  Close( b, "nosave" );
  Close( c, "nosave" );
);

"good start"

"AgencyStay"

"AgencyStay"

"AgencyStay"

"AgencyStay"

"AgencyStay"

"AgencyStay"

"AgencyStay"

"AgencyStay"

"AgencyStay"