Skip to main content
Solved

Compare Attribute with a Excel list

  • January 22, 2018
  • 1 reply
  • 26 views
N
Forum|alt.badge.img

I have an Excel Table with two columns as shown in the picture below. Additionally I have a bunch of features which holds an attribute named INFOTEXT. I would like to compare this attribute of each feature with the SOURCE-column of the Excel. If the string of INFOTEXT and SOURCE is equal I would like to add a new attribute with the content of DESTINATION column on the same row. Is this possible with FME?

Best answer by oscard

Use the FeatureMerger transformer.

Requestor --> Your feature bunch

Supplier --> Your Excel

View original
Did this help you find an answer to your question?

1 reply

oscard
Influencer
Forum|alt.badge.img+21
  • oscardInfluencer
  • Influencer
  • Best Answer
  • January 22, 2018

Use the FeatureMerger transformer.

Requestor --> Your feature bunch

Supplier --> Your Excel

Reply


Helpful Members This Week

Community Stats

31,479
Posts
119,340
Replies
39,097
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement

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.