cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Try the Materials Informatics Toolkit, which is designed to easily handle SMILES data. This and other helpful add-ins are available in the JMP® Marketplace
Choose Language Hide Translation Bar
Steven_Moore
Steven_Moore
Level VI

Appending Data To Table

Sep 3, 2014 11:30 AM (4039 views)

I have a large data table in JMP with several scripts saved to the table.  Each week, I receive additional data via Excel files to append to the data table and repeat the analysis via the saved scripts.  The problem is appending the data to the JMP data table from the Excel files.  Can someone explain how to do this without having to create a whole new data table each time and so that I can utilize the saved scripts?

Thanks!

Steve
2 REPLIES 2
Steven_Moore
Steven_Moore
Level VI

Re: Appending Data To Table

Sep 3, 2014 11:50 AM (3894 views)  |  Posted in reply to message from Steven_Moore 09-03-2014

I think I partially solved my issue.  I was getting an error message that stated that my data types did not match in some columns.  This issue seems to be due to some columns in the Excel spreadsheet have text or dates.  so, the problem is:  How to make the data types acceptable to the JMP table.

Steve
0 Kudos
Steven_Moore
Steven_Moore
Level VI

Re: Appending Data To Table

Sep 3, 2014 12:41 PM (3894 views)  |  Posted in reply to message from Steven_Moore 09-03-2014

Now I have completely answered my own question:  One can update a data table from the original source by running the Source script saved in the data table.  Sorry for wasting people's time on this one!

Steve
0 Kudos