Starting from version 2.1.0, RPA Express (and later - Intelligent Automation Cloud Business) comes with a special ETL bot task that allows you to split data stored in Lists in the middle of the business process, so some bot tasks can be performed for each record without using For Each loop, or can be played in parallel on several desktops (in the Business version and during the 30-day trial).
To use the bot task in the business process:
Open the business process for editing
Find ‘Test split bot etl’ on the list ETL tasks available on the right panel and click Copy
Rename and save the copied task
Add the copied ETL task to the business process before the task that needs to use split data
Double-click on the etl bot task, add name of the variable to split, select variable type (list, table), add the name of the variable to store the split data
NOTE: the current ETL task only works with lists.
Save the bot task and the business process.
The BP used for this example is attached.
Bot task “get company names” receives a list of names from Excel ans saves to the List variable ‘companies’.
Then, the List variables ‘companies’ is split, and each value is stored in a String variable ‘company’.
Bot task “look for rates” opens Yahoo Finance and searches for company stock rates. The bot task uses the data split in the ETL task.
To run the BP, don’t forget to insert the correct path to the Excel file in the input data file.
If you have any questions about using the bot task, please post them in this topic!