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?
Page 1 / 1
Use the FeatureMerger transformer.
Requestor --> Your feature bunch
Supplier --> Your Excel