Question

Dynamically matching two unknown attributes

  • 26 June 2013
  • 1 reply
  • 2 views

Badge
Hi there,

 

 

 

I’d like to know if there is a method to match attributes with similar names.

 

To explain, here’s what the data will look like.

 

 

 

I have a Dynamic workspace that checks all files within two separate folder. So, the intent is to run this workspace on any features contained within, and the names of the shape files contained in those folders can be literally anything.

 

 

 

Let’s say Folder A contains the following files:

 

 

 

10001_AFR_ROADS_V1

 

10001_AFR_WATER_V1

 

10001_AFR_RAILWAYS_V1

 

 

 

And Folder B contains:

 

 

 

10XYZ_afr_Roads_v1

 

10X01_Afr_Water_v1

 

10001_AFR_Railways_v1_0

 

 

 

As you can see, there are similarities, but they are not identical. I want to know if there’s a way to compare the two sources and match any of those files that are “somewhat” similar. Ideally, a percentage. So for example, of it compare two of those files, and it detected that there was an 80% or higher similarity. I don’t need to see the percentage, I just need some leniency on matching the two sources up.

 

 

 

The two sources will always have quite high similarities, but I need this kind of process to compensate for slight differences.

 

 

 

Hope my explanation makes sense.

 

 

 

 

 

Thanks and Regards,

1 reply

Userlevel 4
Badge +13
Hi Robbie,

 

 

I think for this case the fuzzy string comparer from the FME store can be of use.

 

 

Itay

Reply