The Split Workbook activity splits the data of an Excel sheet by the values in a given column and creates a separate workbook for each value. The DataTable returned can conveniently be used by the Queue All Workbooks activity to make a queue item for each workbook to be processed by a Performer. The Performer would consume the queued items which contain the path to the generated workbook files.
Allows a process built to consume a sheet of data to be easily distributed across many robots. Works around file contingency on a single source file by splitting the file into sets of data to be processed separately.
It is especially useful when you have a group of rows in the sheet that represent a true transaction and therefore should be a single transaction in the queue.