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


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


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings