cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • New to JMP? Join us Sept. 23-24 for the Early User Edition of Discovery Summit, tailor-made for new users. Register now for free!
  • Your voice matters! Tell us how you prefer to receive JMP updates, so we can tailor our communication to your needs. Take short survey.
  • See how to access JMP Marketplace - and - find, create & share add-ins to extend your JMP. Watch video.

Discussions

Solve problems, and share tips and tricks with other JMP users.
Choose Language Hide Translation Bar
lisaash
Level I

how do you update a jmp with excel file & not loose the formulas

Hello, do I update a JMP data table with data from excel without loosing the formulas? thanks

4 REPLIES 4
jthi
Super User

Re: how do you update a jmp with excel file & not loose the formulas

Formulas from excel or formulas in JMP table? Are you just adding new data (concatenate) or updating existing data (update/join)?

-Jarmo
hogi
Level XIII

Re: how do you update a jmp with excel file & not loose the formulas

JMP formulas.

the update script should not be called "Update". It's very misleading.

hogi
Level XIII

Re: how do you update a jmp with excel file & not loose the formulas

please refer to this post for further details:
JMP 18 new Update Table script overwrites table 

lisaash
Level I

Re: how do you update a jmp with excel file & not loose the formulas

The formulas in JMP

 

 

Recommended Articles