MapInfo Pro

Hello,

I'm looking for a bit of advice from you clever types.

At work we have GPS units that create .tabs with look up codes in some columns e.g. in the field, when you select the work option 'contractor' on the unit, the exported table will show WOR1 in the work type column in MapInfo.

I've been using vlookup in excel to pull the correct text from the look up table and joining the excel data to the .tab with a UID. This is OK but is there a better way to do this in MapInfo?

I currently have version 10.5.

Kind regards,

Mat

Mat,

The Update Column feature in MapInfo Pro also gives you the option to update one column with values from another table.

When doing so, you need to have the column to update and also you need to specify how to join the two table, for example using the Code columns.

Hi Peter,

I think an excel VLOOKUP is still the fastest route when there are many possible codes to update.

Thanks for your help.

Kind regards,

Mat

You should add index to the columns that you use to match values. This will make the Update Column run much faster.