• Home
  • Forums
  • FME Form
  • Transformers
  • Hi. I have a featureJoiner with 2 tables, from FGDB Esri files. I have to make a query on 1 table. I Can't make the query directly in table because i have other featurejoiner from this table. I hope it's clear. Than for your help. I
Question

Hi. I have a featureJoiner with 2 tables, from FGDB Esri files. I have to make a query on 1 table. I Can't make the query directly in table because i have other featurejoiner from this table. I hope it's clear. Than for your help. I

  • 11 February 2021
  • 3 replies
  • 0 views
H
Hi. I have a featureJoiner with 2 tables, from FGDB Esri files. I have to make a query on 1 table. I Can't make the query directly in table because i have other featurejoiner from this table. I hope it's clear. Than for your help. I

3 replies

M
Badge +2

@hugues​ Can you expand on what the problem is and what you need to accomplish? Are you encountering an error?

H

I have a table. This table have field (FWD_id) that it's can be null. I make a featurejoiner with a other table with the same field (FWD_id), and on the second table is can be null to. I make the join on the field FWD_id. I need to validate that the record on the first table with FWD_id not null value can be link with the second table on the field FWD_id. Thank you.

 

M
Badge +2

@hugues​ You can use a TestFilter to test for <null> or NOT <null> - this will filter out the records that have a <null> FWD_id. You can then use the FeatureJoiner to join the two records using FWD_id. If there is no match, then you'll see those in the UnmatchedLeft and UnmatchedRight ports.

Reply


Community Stats

28,707
Posts
109,479
Replies
36,553
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.