Is there a way I can refresh the 'Source' data without it launching a new table? Or is it possible for the saved scripts to get carried over into the new table?

Question

I have set up a template to monitor our processes. The data table is linked to a sharepoint file that is a living document that will be updated on occasion.

The goal was to never have to manually copy / import anything into jmp but have all the analytics available at the press of a button.

Currently, when I try to refresh the data by pressing the "Source" script it launches a new table, which is not ideal but could be more workable if it at least carried all the other saved scripts with it to the new table.

Basically looking for a way to update the existing table with fresh data or pull the existing scripts into the new table that is generated.

Thanks!

Screenshot 2026-03-02 152444.png

hogi · Answer

Wonderful trick: save the data on a cloud space and use a Data Connector.
-> I added it to the wish: universal "update" button for imported data

Thanks!

christian-z · Answer

Hello @LambdaErmine807 ! You say "The data table is linked to a sharepoint file". How is it linked?

When I create a data table using a Data Connector (such as the Sharepoint Data Connector), I get not only a "Source" script, but also an "Update" Script.

* Source generates a new table the same way the table was first generated - all changes and edits are lost
* Update script refreshes the data from the linked data source, but keeps the existing table including all saved Data Table Scripts, Formula Columns, etc.

If you tell me more about how you have "Linked" to the Sharepoint file, I might be able to offer more ideas. (Edit: also, what is the filetype/extension of your source data file?)

"Basically looking for a way to update the existing table with fresh data" - have you tried the OneDrive and SharePoint Data Connectors? Basically, the idea is to treat your Sharepoint file as a Database to be queried (edit: using Query Builder), rather than as a file to be copy-pasted. The initial setup takes a few minutes, but it makes operations like data refresh/updating much smoother.

>>Edited in a few places to clarify.

hogi · Answer

modify the source scrpit, or use it as an input for the update:

dt = Current Data Table();
dtnew = dt << Run Script( "Source" );
dt << Select All Rows << Delete Rows;
dt << Concatenate( dtnew, Append to first table );
Close( dtnew, NoSave );

from: https://community.jmp.com/t5/JMP-Wish-List/Join-Concat-and-Update/idc-p/847429/highlight/true#M7156 
on #DiscoverySummit2025, we discussed this workaround.

The Script uses the Source data table, and replaces the content of the table with the new data

Due to a "bug" in JMP (00154993), this workaround it's very fragile:
If a table is updated via Tables/Update, the existing Source script is overwritten with the auto-generated one (!)

We already discussed the issue on #DiscoverySummit2025

-> I will highlight the issue again on #DiscoverySummit2026 , maybe there is a possibility to fix the bug.
Then the workaround will run smoothly ...

another option:

add a universal update button - like in other programs:
universal "update" button for imported data 
the with was merged with:
Join, Concat and Update - please vote there.