Skip to main content
  • EN

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.
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.

 

 

Reply


Community Stats

30,108
Posts
114,295
Replies
37,743
Members
Terms & ConditionsCookie 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.