Use Attribute Assistant to fake a 1-M join

[CraigCarsley]

I have a RoadCenterline feature class, and have added the parsed FULLNAME attribute fields (ROADPREDIR, ROADNAME, ROADTYPE, ROADPOSTDIR).  I would like to get the associated data for each RoadCenterline feature from its match in the MasterStreetName table.

I originally attempted to do this with a simple join, but it's not working correctly.  The issue seems to be in the one-to-many nature of the relationship; each MasterStreetName record applies to many RoadCenterline features.

I thought I might be able to concoct a solution using the DynamicValue table.  I'm just not sure which value methods to use, or how to go about doing it efficiently.

Does anyone have any ideas, or direction?

Thanks!

[JeffMiller]

Hey CJ,

      If you wanted to go the attribute assistant route, I think you could accomplish this by using the expression value method for each of your parsed fields, using a vb expression to pull out the individual items from the combined name field. 

      However, perhaps an easier method may be to use the standardize addresses geoprocessing tool.  There you should be able to select which fields you want the individual parts of the address to fall into.  I may take a look at that 🙂

[CraigCarsley]

Thanks for the response!

I ended up creating my on geoprocessing model to accomplish this.  I couldn't get the standardize addresses tool to work effectively.
If anyone gets stuck on this, I'm happy to share my model.. works great!