For the latest version of JMP Help, visit JMP.com/help.


Using JMP > Reshape Data > Update Data Tables
Publication date: 04/30/2021

Update Data Tables

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.

Before you update a table, make sure that the name of the column containing the values that you want to replace is the same as the name of the column containing the data that you want to replace it with.

To replace values in the active table with those found in another open table

1. Click the original table that you want to update (this is the table whose values you want to replace) to make it the active table.

2. Select Tables > Update.

Figure 6.48 Updating a Table 

3. Highlight the new table containing the data that you want to transfer to the original 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.

6. From the Add Columns from Update Table area, select an option. Using these options, you can add columns (that do not exist) from the new table into the original table.

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. (Optional) From the Replace Columns in Main Table area, select an option, Using these options, you can replace the values in columns that have similar names.

Choose All to add all columns with similar names from the new table into the original table.

Choose Selected to replace only columns with similar names 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 that have similar names from the new table into the original table.

8. Click OK.

To update a table using matching columns

1. Follow the first three steps outlined in the previous section, To replace values in the active table with those found in another open table.

2. Select Match columns.

Figure 6.49 This Window Appears When You Click Match Columns 

3. Highlight the two column names (in the respective tables) that you want to match.

4. Click Match.

5. (Optional) Repeat to match more columns.

6. Click OK.

Note: Columns that have different names from the columns in the table that you are updating (and that have not been assigned matches) are appended as separate columns. To avoid this problem, select the None option in the Add Columns from Update table area.

Want more information? Have questions? Get answers in the JMP User Community (community.jmp.com).