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?
