Skip to main content
Solved

How to compare/match 2 datasets, populate new attribute for matched records?

  • June 11, 2014
  • 1 reply
  • 74 views
M

So I have a dataset of points that is coming from an ESRI Geodatabase, the other is a list of "inoperable" valves in an Excel spreadsheet.  I would like to match an attribute from the ESRI dataset, "Valve_ID1," with an attribute from the Excel spreadsheet, "Valve_ID2."  For the matching records I'd like to output only 1 feature each (ignore the Excel spreadsheet due to no geometry, not all valves will have a match).  Both matched and unmatched data will need a new attribute called "Condition."  The matched records will be populated with "Inoperable" and the unmatched should just have a blank record.  The unmatched records from the Excel spreadsheet should be thrown out all together if possible.

 

 

I currently am using the "Matcher" transformer but the output contains the Excel records that are not matched as well as no matched records even thought I know there are at least 7.

Best answer by matthewbrucker

Use a FeatureMerger with the Requestor being the ESRI dataset and the Supplier being the Excel worksheet. 

 

 

Pick the corresponding "Join On" fields for the Requestor and Supplier in the properties.

 

 

On the Merged Output, add an AttributeCreator transformer. Name the field Condition and the value as inoperable.

 

 

On the NotMerged output, add an AttributeCreator. Name the field Condition and leave the value blank.

 

 

View original
Did this help you find an answer to your question?
This post is closed to further activity.
It may be a question with a best answer, an implemented idea, or just a post needing no comment.
If you have a follow-up or related question, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

1 reply

M
Forum|alt.badge.img
Use a FeatureMerger with the Requestor being the ESRI dataset and the Supplier being the Excel worksheet. 

 

 

Pick the corresponding "Join On" fields for the Requestor and Supplier in the properties.

 

 

On the Merged Output, add an AttributeCreator transformer. Name the field Condition and the value as inoperable.

 

 

On the NotMerged output, add an AttributeCreator. Name the field Condition and leave the value blank.

 

 

Helpful Members This Week

Community Stats

31,331
Posts
118,863
Replies
38,957
Members

Latest FME

Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.