Conditionally Merge Data from Two tables
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.
Best Answer
Hi @mark_1spatial, two NullAttributeMappers might help you.
- Change the value "N" to <missing> with the 1st NullAttributeMapper before merging.
- Set "Yes" to the "Process Duplicate Suppliers" parameter of the FeatureMerger.
- 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)
