cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • We’re improving the Learn JMP page, and want your feedback! Take the survey
  • JMP monthly Newswire gives user tips and learning events. Subscribe
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