Skip to main content
  • EN
  • Home
  • Forums
  • FME Form
  • Transformers
  • Is it possible to exclude keys already present in a table from a second table before performing translations on that second table?

In my data, I have 3 Oracle tables (numbered for ease of explanation);

1) a spatial table with geometries of tubes used as casings for HV-cables

2) a spatial table with the geometries of the actual HV-cables

3) a non-spatial table with the connection between the tubes and the cables they contain (essentially displaying which key(s) in table 1 is(/are) matched to which key(s) in table 2

 

What I'm interested in is isolating the tubes which have a cable running through (/on top of) them based on a spatial analysis, but aren't yet connected in table 3. Therefore, I'm looking to exclude all tubes with a key present in table 3 from table 1 before progressing with the other translations (which are going well), but I'm not getting anywhere with Matcher. Is there any other transformer to use here?

One possible solution is to use the FeatureMerger and look at the output from the UnmergedRequestor port. You can do this either before or after doing the spatial matching.

One possible solution is to use the FeatureMerger and look at the output from the UnmergedRequestor port. You can do this either before or after doing the spatial matching.

Agreed, but I would suspect before the spatial matching would give better performance.

Agreed, but I would suspect before the spatial matching would give better performance.

Agree, in particular if you can get rid of a consequential amount of data this way.

Reply


Community Stats

30,189
Posts
114,584
Replies
37,854
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.