Skip to end of metadata
Go to start of metadata

Available from RPA Express 2.1.3.

In some cases, it is required to split data in the middle of the business process (BP).

  • One of the bot tasks in BP generates data stored in the list (table), and the next bot task needs to be executed for each record in the list (table). Users cannot provide the data records as a .csv input data file as they are received during BP execution and are not available before the BP starts.
  • One or several bot tasks need to be executed only once in BP, while other tasks need to run for each data record. Users cannot provide several records in a .csv input data file as some tasks need to be executed only once.

The solution is to split data in the middle of BP using a special Bot Form (ETL task) "Test split bot etl".

It will allow to:

  • execute certain steps for each data record without the need to use For Each loop in the recording,
  • run these steps in parallel on several nodes (desktops) without the need to provide the records in the input file,

thus combining the benefits of the two approaches of implementing loops in Control Tower.


The diagram below shows a sample workflow of a business process using a task to split data in the middle of the process so the last step can be executed by several bots in parallel.

The guide below demonstrates how to use the bot task in BP based on two simple use cases

Use Case 1. Splitting List Variable

Description

There is a list of emails stored in an Excel file. The bot needs to retrieve the emails and send the same message to all recipients.

Downloadable materials

You can download the archive with the source materials used for the case to see how the Data split bot task works in practice.

The archive contains:

  • two recordings made in RPA Express 2.1.1
  • BP package
  • .csv input data file for BP

Note that you need to provide the Excel file with email addresses and specify the file path in the input data file for BP to work correctly.

BP consists of two bot tasks implemented in WorkFusion Studio.

  • Bot task 1 gets the emails from the Excel file and saves them in a List variable.
  • Bot task 2 sends a message to the email address received in Bot task 1.

Implementation

To implement the workflow, split the data stored in the emails variable after Bot task 1 into several records before the second step is performed, so that it can be executed in parallel on all available nodes.

After publishing both bot tasks (recordings) to Control Tower, do as follows.

  1. Create a new business process and add both bot tasks to the workflow.
  2. Find the Test split data etl task on the right panel on the Workflow tab. Click Copy.
  3. Rename and save the task.
  4. Add the task to the workflow before the Sending-emails step.
  5. Double-click the ETL task, specify the variable to split, select the List type, and specify the variable to save the split data to.
  6. Save the task.

Result

There are 14 email addresses in the Excel file. Thus, Bot task 1 is executed once, while Bot task 2 is executed 14 times (once fore each email address) in parallel, which significantly speeds up BP execution.

Use Case 2. Splitting Table Variable

Description

There is a table with new employees details stored in an Excel file. The bot needs to retrieve the contact details and fill in an online form for each employee.

Downloadable materials

You can download the archive with the source materials used for the case to see how the Data split bot task works in practice.

The archive contains:

  • two recordings made in RPA Express 2.1.1
  • BP package
  • .csv input data file for BP
  • Excel file with sample data

Note that you need to specify the file path in the input data file for BP to work correctly.

BP consists of two bot tasks implemented in WorkFusion Studio.

  • Bot task 1 gets the employee details from an Excel file and saves them in a Table variable.
  • Bot task 2 fills in a web form with information about each employee (each row in the table).

Implementation

To implement the workflow, split the data stored in the employees table after Bot task 1 into separate lists (rows containing employee information) before the second step is performed, so that it can be executed in parallel on all available nodes.

To do it, add the ETL task to the workflow as described above.

Configure the Data split task as follows.

  1. Specify the variables to split and to save the data to.
  2. Set the Table type.
  3. Select whether to split data by rows or by columns. In this use case, the information about each employee is contained in a separate row in the file, so select the Row option.

Result

There are 50 rows in the Excel file. Thus, Bot task 1 is executed once, while Bot task 2 is executed 50 times (once for each row) in parallel.

  • No labels