Question

Updating master Excel sheet from multiple sheets

  • 24 August 2022
  • 1 reply
  • 3 views
A

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.

2 Attachments

1 reply

M
Badge +2

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

Reply


Community Stats

28,661
Posts
109,317
Replies
36,527
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.