I have two sets of data that I need to combine. One is a GIS set of points corresponding to the centroids of buildings, the other is a CDV table that has data about what these buildings are used for. I'd like to colour the buildings appropriately depending on this use variable.
This means both adding the bldg_use variable to the attribute table for the centroids, as well as making sure the right use gets assigned to the right building. We use 11-digit codes to name buildings, and this is present in both datasets.
What might I write to automatically check name matches?