Skip to main content
  • EN

I have two tables, ITEM and SITE, where the ITEM values(columns ACTIVE, CHECKED, REPLACE) need to be merged with the SITE columns but if any of the multiple ITEM values is 'Y' it takes precedence over a value of 'N'. I have a solution using a FeatureMerger generating a list and then searching the list three times, once for each column.

However, this is an example and actually there are many columns that need to be added in this way. Just wondering if there is a more generic way of processing rather than a chained approach (no Python please).

Data in attached spreadsheet.

 

 

Hi @mark_1spatial, two NullAttributeMappers might help you.

  1. Change the value "N" to <missing> with the 1st NullAttributeMapper before merging.
  2. Set "Yes" to the "Process Duplicate Suppliers" parameter of the FeatureMerger.
  3. Assign "N" to the missing ACTIVE, CHECKED and REPLACE columns with the 2nd NullAttributeMapper after merging.

See also the attached example: nullattributemapper-example.fmw (FME 2016.1)

Hi @mark_1spatial, two NullAttributeMappers might help you.

  1. Change the value "N" to <missing> with the 1st NullAttributeMapper before merging.
  2. Set "Yes" to the "Process Duplicate Suppliers" parameter of the FeatureMerger.
  3. Assign "N" to the missing ACTIVE, CHECKED and REPLACE columns with the 2nd NullAttributeMapper after merging.

See also the attached example: nullattributemapper-example.fmw (FME 2016.1)

As always you make it look too simple. FME Legend!

Many Thanks

Reply


Community Stats

30,117
Posts
114,317
Replies
37,748
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.