Skip to main content
Solved

Compare Attribute with a Excel list

  • January 22, 2018
  • 1 reply
  • 34 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

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, 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

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

Use the FeatureMerger transformer.

Requestor --> Your feature bunch

Supplier --> Your Excel

Community Stats

32,154
Posts
122,048
Replies
39,812
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement
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.