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?
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.
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!