cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • Register to attend Discovery Summit 2025 Online: Early Users Edition, Sept. 24-25.
  • New JMP features coming to desktops everywhere this September. Sign up to learn more at jmp.com/launch.
Choose Language Hide Translation Bar
jadeyan
Level I

Can JMP data table be updated with new input from same excel file

Can JMP data table be updated from same excel file with new input only

2 REPLIES 2
jthi
Super User

Re: Can JMP data table be updated with new input from same excel file

I have simple excel file

jthi_1-1748413783632.png

 

imported to JMP

jthi_0-1748413774798.png

When new lines get added

jthi_2-1748413800114.png

I can use Update Table table script to update the data. It might be that JMP loads all the data and then updates the corresponding columns 

jthi_3-1748413829253.png

Depending on how your data gets updated, you could also create a Workflow to handle the updates

-Jarmo
hogi
Level XII

Re: Can JMP data table be updated with new input from same excel file

please note that any processing steps (new columns, formatting, grouping)  will be deleted during the "update".
For "new columns", there is a warning - the other settings get deleted without a warning.

hogi_0-1748454737513.png

 

 

there are several posts in the wish list to optimize the behavior.

Join, Concat and Update 

universal "update" button for imported data 

Please support them if you need functionality beyond what is possible at the moment in JMP.

Recommended Articles