Skip to main content
  • EN
  • Home
  • Forums
  • FME Form
  • Transformers
  • Extract features from an excel file and merge with polygon Some of the rows will have a ‘Y’ against a ward or some wards that the informati

I have a large excel file with multiple columns with different attribute information, some of these columns have information about the local authority wards, for example;

Excel Extract 

Some of the rows will have a ‘Y’ against a ward or some wards that the information relates to.

For each row I want to match fields that have a ‘Y’ and merge with the ward polygon file creating a polygon of the matched wards, so for the above example there with a polygon file with 4 wards.

Any suggestions on the best way to approach this?

 

Thank you in advance.

I'd take a look at the AttributeExploder, this will return a feature for each attribute, with _attr_name and _attr_value. Test for _attr_value = 'Y' and that should return 4 features. You can then featuremerge/featurejoin using the _attr_name field as your join/merge

Thanks I will give that a try

 

Reply


Community Stats

30,177
Posts
114,555
Replies
37,843
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.