Output Tool

SB09

I am trying to split the data based on one column values into separate excel sheets.
The error I get is No Sheet selected.
When I change the configuration and provide File location and uncheck the option Take File/Table from Field, the workflow runs but the aim is not reached.

Error.JPG

DatatoMultipleSheets.yxmd

RolandSchubert

Hi @SB09 ,

I think, the error is caused by the last (empty) row in your Text Input tool. Delete row 6 in the Text Input tool and it should work fine.

Let me know if it works for you.

Best,

Roland