Skip to main content
  • EN
  • Home
  • Forums
  • FME Form
  • Data
  • Merge features from Table A using a field value to Table B if the Table A value matches one of a set of comma delimited values in a field in Table B

A have one dataset (Dataset A) that has contains fields, one of which is CityName; example value “Sudbury”. I have another dataset (Dataset 😎 that contains a field made up of comma delimited AltNames; example value “Gran Sudbury,Grand Sudbury,Sudbury, etc.

I need for these features to be joined in one dataset if the value in CityName matches any one of the comma delimited names in AltNames, however different records have different numbers of alternate names and it cannot match with a section of a comma delimited value. For example, Sudbury != Grand Sudbury.

I think that lists may solve this but I’m not familiar with the transformers that might enable this process.

You could first use the AttributeSplitter to turn your field of delimited names into a list. You could utilize a ListExploder and then Join/Merge how you need.

Worked perfectly, Thanks so much!

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.