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.
.
