topic Re: 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? in Discussions

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?

LambdaErmine807 — Mon, 02 Mar 2026 23:27:50 GMT

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?

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!

Re: 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?

jthi — Tue, 03 Mar 2026 05:53:25 GMT

I don't think you can directly achieve those (Source which would just update the data / table scripts copied over to new table created using Source) unless you modify the Source script. Have you considered creating a workflow which would be run to create the data table?

Re: 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?

hogi — Tue, 03 Mar 2026 07:40:34 GMT

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:

the with was merged with:
- please vote there.

Re: 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?

christian-z — Tue, 03 Mar 2026 09:51:11 GMT

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.

Re: 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?

hogi — Tue, 03 Mar 2026 19:57:08 GMT

Wonderful trick: save the data on a cloud space and use a Data Connector.
-> I added it to the wish:

Thanks!