Video shows how to update a JMP data table to reflect Excel updates. Because JMP is intended to be hands on & generally doesn’t encourage automation, you go back to JMP to re-run the script again. Note: when you run the script in JMP, it will not copy over the Control Chart script or any other scripts you have saved in the Tables Panel, so you may want to append that to the Source script. A more automated sequence would involve scripting using JSL.
Here are some Scripting Resources:
I follower your instructions in your video regarding "How to update a JMP data table to reflect Excel updates" subject.
However, instead of updating the existing table, a new table with the updated data is created. How can i make the master table to be updated it without having a duplicate table so that i am forced to use the "Update Table" function available under the Table menu?
@kmouloua that's a bit trickier since it requires that you
If you have these three things, opening an Excel worksheet via the Open Database option will create a table script Update from DB which will update the table in place.