Skip to main content
  • EN
Hi,

 

I am working with FME 14 on a Win7 machine (8Gb).

 

I have temopral data of same dataset where the columns are 'Official Name', 'Brand Name', 'FeatureId' etc.

 

So, what I need to do is-

 

1) Find out how many FeatureId are matching.

 

2) Only if the FeatureId is matching, then how many Official Names, Brand Names, etc are matching.

 

 

I tried doing it with Matcher. I got the FeatureIds correct. Now, if I connect the output of FeatureID to check for Brand Names, the output is wrong. But, when I connect Brand Names with reader, the output is awesome.

 

Is there a way to get it correct? ):
Hi,

 

 

I'm not sure what is the exact requirement...

 

If you need to find features that have identical combination of Feature ID and Brand Name, specify the two attributes to the "Selected Attributes" parameter of the Matcher.

 

 

Takashi
Hi Takashi. PFA for more detailed description.

 

I have two inputs of same dataset but different releases.

 

- Using Matcher, I matched FeatureId.

 

- Now, in the next step, I want to match 'OfficialName', but only those number of 'OfficialName' where 'FeatureId' is already matched.

 

 

Applying another Matcher in series is not giving the desired o/p. Neither selecting FeatureId and OfficialName in one Matcher.

 

How about using the ChangeDetector?

 

Send the PRE features to the Original port; send the POST features to the Revised port.

 

Match Geometry: NONE

 

Attribute Matching Strategy: Match Selected Attributes

 

Selected Attributes: FeatureID, OfficialName

 

 

Then,

 

- Matched features go to the Unchanged port.

 

- Unmatched POST features go to the Added port.

 

- Unmatched PRE features go to the Deleted port.
Hi Takashi. Thanks for your help.

 

The problem with ChangeDetector I felt was that, it gives a count of Added and Deleted attributes only on the basis of a field (FeatureId in my case) and I wanted the count of those field which were edited.

 

So, for that I used a different method, long and hectic, but still working.

 

I copied the attributes from one dataset to another, making sure that all fields are in a single dataset. Now, I used FuzzyStringComparer. On the basis of that, I got the unmatched components (the edited ones).

 

This method is a bit long. Any other instances to resolve this issue?

Reply


Community Stats

30,108
Posts
114,295
Replies
37,744
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.