Hello,
Assistance required - in single excel sheet there are multiple tables in one sheet. Can anyone plz suggest how to break those multiple tables into multiple tabs or sheets in out put file.
Thanks
hi @Rajeev18
You can output to multiple sheets by single Output tool.
First, create a column which row will be output to which sheets like this. To do so, Multi Row Formula tool will help.
With this, specify output option like this to output to multiple sheet at one time.
For more detail, please check the attached WF to see how it works.