Different Outputs When I run the Script Again

Question

Hi,

I have a script that manipulates my data table. When I run the script again and the manipulated data table is open the script runs on the already manipulated data table, even though I haven't saved that data table with the same file name as the original. Is there any way to stop this from happening and to only run the script on the original data table? Any help would be appreciated.

gzmorgan0 · Answer

Jeff,

When I read the documentation on the option Force Refresh that only applies to .jrn, .jsl, .jrp, or .jmpappsource files, I always wondered why JMP decided not to apply it to .jmp files, or have an option Force Refresh Close, that forces all dependent windows to close.  In my opinion, this would be a useful option, especially when developing an application or debugging a script.

Jeff_Perkinson · Answer

Open() doesn't re-open an already open file.

If you want to revert to the saved version of the table, you'll need to close it without saving it before you open it again.

Jaz · Answer

This script, for example:

dn = Open("Numbers.jmp");
Current Data Table(dn); 
Column("Numbers");
colNumbers = Column(1); 
Column(dn, "Numbers") << Data Type( Numeric );
For Each Row(
	dn:colNumbers = dn:colNumbers + 1; 
);

It keeps incrementing each row by one each time I run the script. But I didn't save the data table the first time I ran the script so why does it increment the unsaved data table? Are you suggesting that because the first time I ran the script the data table is the current data table and that's why it updates the current data table instead of the original? If so, how could I make it so each time I run the script it only manipulates the original data table?