Solved

Relate Records and update a field

  • 1 December 2022
  • 2 replies
  • 3 views

Userlevel 1
Badge +15

I have two Geodatabase Feature Classes, FC1 and FC2.

 

I want to relate the GIS_ADDR field in FC1 to the ADDR_BASE field in FC2.

 

Once the relate is established, for the matching (selected) records in GIS_ADDR in FC1, I will then update the ADDR_SRCE field which is currently empty with the value "ADS"; for the records that do not match I will add the value "Res".

 

I know how to do this in ArcGIS Pro. What is the best approach to do this in FME?

icon

Best answer by dustin 1 December 2022, 19:43

View original

2 replies

Userlevel 3
Badge +26

I would use a FeatureMerger. FC1 would go into the Requestor port, FC2 would go into the Supplier port. You will need to set the GIS_ADDR and ADDR_BASE fields in the Join On parameters of the FeatureMerger. Then from the Merged and UnmergedRequestor ports, feed those into 2 separate AttributeCreators. In each of those you can set the ADDR_SRCE field to your values.

Userlevel 1
Badge +15

@dustin​ thank you. I also tried it using AttributeManager instead of AttributeCreator. That also worked. Your suggestion seems more logical.

Reply