I have two shapefiles as shown in attached picture:
Buildings footprint (polygons) which includes house number and street name beside other fields.
Red shapes (polygons) which include house number and street name with information for each building distributed in many fields.
The common fields in both shapefiles are house number and street name.
The task is creating new layer that contains Buildings footprint (target features) with corresponding Red shapes (join features) based on matching house number and street name (common fields).
For example in the attached image:
Red shape No. 1 shall be joined to building 18 (same house number & street name for both).
Red shape No. 2 shall be joined to building 16 (same house number & street name for both).
I tried "Spatial Join" with match options INTERSECT, HAVE_THEIR_CENTER_IN and WITHIN_A_DISTANCE, but i can't achieve the desired result.
How I would do that in ArcMap 10.3 ModelBuilder?