Updating JMP Data Tables

[#1]

In September, I posted a question about updating JMP Data Tables, but got no replies.  However, I was able to figure it out and feel that others might have the same problem.  The Tables<Update works fine if you have changed existing data in your master data table.  However, if you add rows of data to the bottom of your master table, the new data will not update.   This was driving me crazy until I tried adding blank rows to the JMP Data Table that I wished to update from the master.  Then, the Tables<Update function works fine.  Of course, you can always just copy and paste the new data.

I hope this helps someone out there!

Maybe this is an enhancement that needs to be included in the next JMP update.

[#2 · Accepted solution]

My whole post did not appear.  To update a JMP Data Table when you have rows of data to be added from the master file, you have to add blank rows to the Data Table first, or nothing will happen.  Otherwise, the Tables<Update function only updates previously existing data that have been changed.

[#3 · Accepted solution]

I believe that you can bypass the requirement to add new blank rows, if instead of using an "Update" you use a "Join", matching same name columns and specifying to keep all rows from the master table, even if it finds no match.