how to combine two attribute table in acgis through model builder?

Question

I am working with two attribute tables shown below. I want to join Centroid_Sites_Fbr (objectID) to Centroid_Sites_Fiber (In_FID). As you can see Centroid_Sites_Fiber contains multiple values for some records. I want to join these two tables where output should have all 15 ObjectId plus the multiple data from Centroid_Sites_Fiber table. Any help is appreciated.

Thanks

MG

LukeSturtevant · Answer

Sure. It would definitely help to know what your attribute fields are that you are trying to update. If you could either send a sample dataset of Centroid_Sites_Fbr   and Centroid_Sites_Fiber or at least provide a screen shot of the full attribute tables that would help us get started. Thanks.

ManjariGoyal · Answer

Hi Luke,

That will be great if I can get the python script which will update the table with all the rows from the second table.

Thanks

MG

Sent from my iPhone

LukeSturtevant · Answer

I'm not sure how you would do this through model builder. You could add the fields you want to populate in your Centroid_Sites_Fbr  and use python to set up a search cursor​ on Centroid_Sites_Fiber and set up an update cursor​ for Centroid_Sites_Fbr to populate the fields according to the OID@. If that is something you are interested in I'm sure we could set up the code really quick to help you along.