If you have two data tables and would like to update your original table with data from a new table, select Tables > Update. The Update command is a special case of Join in place. It is a Join with the Update option checked, and it does not result in a new table.
|
2.
|
Select Tables > Update.
|
Figure 6.43 Updating a Table
|
4.
|
(Optional) If you do not want JMP to replace the values in the original table with any missing values found in the new table, select the box next to Ignore missing. The original table retains its original values if they correspond to missing values in the new table.
|
|
5.
|
If the two tables have one or more columns whose values uniquely describe each row, JMP uses those columns as the match column values. That is, JMP updates the rows whose match column values coincide. JMP uses these columns to preserve the sorted order of the data. If your tables do not have matching column values, you can incorporate the updated values according to their row order by continuing here. To proceed with tables containing matching column values, see To update a table using matching columns.
|
|
–
|
Choose All to add all columns from the new table into the original table.
|
|
–
|
Choose Selected to add only columns that you have selected from the new table into the original table.
|
|
–
|
Choose None if you do not want to add any non-existent columns from the new table into the original table.
|
|
7.
|
Click OK.
|
|
1.
|
|
2.
|
Select Match columns.
|
Figure 6.44 This Window Appears When You Click Match Columns
|
4.
|
Click Match.
|
|
6.
|
Click OK.
|