Skip to main content
  • EN

Hello, 

I am having difficulties creating a spreadsheet with 2 sheets. In the screenshots included I have 2 Excel Writers. I have chosen Fanout Dataset since I want the file name to include a timestamp. The workspace runs successfully. But only a single sheet in the spreadsheet is written. 

Daily Totals is included as a sheet in the spreadsheet, and Running Total is not. What do I need to do in order to include both sheets: Daily Totals and Running Total (seen as two Writers in the screenshots below).

 

When I do not choose Fanout Dataset, the two sheets are written to the spreadsheet, but the file name has no timestamp. When I use Fanout Dataset one sheet is written to the spreadsheet and the file name has the timestamp. 

 

My workspace includes the DateTimeStamper Transformer that creates the _timestamp attribute.

.

 

 

 

 

I solved the problem. My DateTimeStamper Transformer was not included in the part of the workbench that writes to the 2nd sheet in the spreadsheet. This transformer was only included in the part of the workbench that writes to the 1st spreadsheet. 

I moved the DateTimeStamper Transformer to be immediately after the Reader to ensure both Writers receive the DateTimeStamp. 

Community Stats

31,852
Posts
120,986
Replies
39,485
Members

Latest FME

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.