Skip to main content
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

  • February 11, 2021
  • 3 replies
  • 4 views

hugues
Contributor
Forum|alt.badge.img+2
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

Forum|alt.badge.img+2
  • 1891 replies
  • February 11, 2021

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


hugues
Contributor
Forum|alt.badge.img+2
  • Author
  • Contributor
  • 9 replies
  • February 11, 2021

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.

 


Forum|alt.badge.img+2
  • 1891 replies
  • February 12, 2021

@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.