Solved

Conditionally Merge Data from Two tables


Badge +2

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.

 

 

icon

Best answer by takashi 27 May 2016, 13:05

View original

2 replies

Userlevel 2
Badge +17

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)

Badge +2

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