Skip to main content
  • EN

Hello,

I am trying to set up a simple flow to automatically copy new or changed data from multiple excel sheets into the master Excel sheet that lot of PowerBi dashboards feed from. The flow is simple as follows:

-Read from sheets -> Attribute Manager (rename to match main excel) -> Change Detector -> Attribute Creator (fme_db_operation (UPDATE)) -> NullAttributeMapper -> Writer.

 

Problem is at the last stage, the writer is not updating the main sheet and could not find the correct setting messing around with the writer parameters. Any help would be appreciated, I have attached the screenshots below.

@ao99​ I think you need to also include the Row Number so the Excel writer knows which row to update

Reply


Community Stats

30,162
Posts
114,509
Replies
37,819
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.