Skip to main content
Question

I have a task in which I have to join tables based on a common attribute in both tables and on the joined table I have to update attributes from the second table.


fme_can_do_it
Enthusiast
Forum|alt.badge.img+11

 For example, I have a CreateNode Field in one table, I have to filter out Null and populate these null values Using the second table that has the same field name. the output is not something It should be. I have attached a screenshot of my workspace. Any help would be greatly appreciated!

3 replies

redgeographics
Celebrity
Forum|alt.badge.img+50

If the field is null in one of your tables, how will you join it with the other one? There has to be an attribute (or combination of attributes) that you can use to join on.


fme_can_do_it
Enthusiast
Forum|alt.badge.img+11
  • Author
  • Enthusiast
  • November 9, 2021

I am joining tables based on the ID field and it's populated in both tables. Once the tables are joined then I will need to query other fields, for example, CreateNode field to see if it is Null, if it's Null then I will copy attributes from the joined table that has the same field and has attributes.


redgeographics
Celebrity
Forum|alt.badge.img+50
fme_can_do_it wrote:

I am joining tables based on the ID field and it's populated in both tables. Once the tables are joined then I will need to query other fields, for example, CreateNode field to see if it is Null, if it's Null then I will copy attributes from the joined table that has the same field and has attributes.

If you use a FeatureMerger and send the features which have the null values in as Requestors you can make it copy the values from the Suppliers (assuming the attributes have the same name of course) by setting the "Ignore Nulls" parameter to Yes.


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