Use Update Column to add temporary columns to a table by using data from another table.
To add a temporary column:
- Open at least two tables.
- on the TABLE tab, in the Edit group, click Update Column to open the Update Column dialog box.
- In the Table to Update list, choose the table to add the temporary column to.
- In the Get Value from Table list, choose the table that MapInfo Pro will retrieve the update information from.
- To add a temporary column, select the Add new temporary column option from the Column to Update list.
If necessary, specify the information MapInfo Pro will need to associate the data (join) in the two tables by using their common tabular or graphic data.
- Choose how to produce the column data by specifying how to calculate the information based on columns and expressions from the Calculate and of lists.
- Select the Browse Results check box to display the table with its new temporary column in browser format.
- Click OK.
The temporary column is added based on the specified information.
When you make changes to the data table, the new temporary column is automatically updated.
To save the table with its new temporary columns, on the TABLE tab, in the Content group, on the Save list, click Save Table. If the temporary columns are added to a table in a workspace, the changes are automatically saved when you save the workspace.