Hello, I am new to FME and could use some help with the FME FeatureMerger Transformer. I have two excel files that contains a matching key field, however I am unable to pull in the 'other' column of data associated to the key fields.

The Requestor and Supplier attributes should be the column that the key attribute is in for both tables, the additional data will be added automatically as you have accumulation mode set to Merge Supplier (I'm presuming your key field is SITE_SPAN_NFID and Site-Span_Span Name is the field with additional data)

e.g. join on NFID, NAME gets added from supplier

Thank you so much for the reply!

So I have it joined on the key field, and have merge supplier set, however the other accumulated data is not ported over...I'm not sure why

I think I just figured it out!

I had the same field name in both tables...Site-Span_Span Name, which is the field that I wanted filled out in the Requestor. However, I just removed that field from the Requestor table, and ran it through to Inspector and was able to get the accumulated data to populate!

thank you so much! you helped me take a look at the accumulation portion which in turn got me looking/thinking about that field I had created.

Removing the attribute from the requestor will work, but you can also set the Conflict Resolution (under Attribute Accumulation) to Use Supplier. This will pick use data from the supplier if the attribute exists on both tables

ah right on!thank you so much!! that's def good to know.

on a follow up to this, i'm not running into the issue of writing it out.

i have chosen to write the output to an excel file based off of a template, but it appears to be writing to a new sheet within the workbook, and not overwriting/updating the main sheet in the workbook.

do i need to set the values here?

and here's a few more screenshots of my writer parameters:

Trying to help define the issue we are facing. We are trying to update a EXISTING sheet using the template. All we are trying to do is add in the key fields from the combined tables into the writer output table.