Adding multiple collection into a collection

Question

I am new to blue prism.

I want to add multiple collections in my collection. Business Scenario:

I have multiple sheets in an excel file. I have converted sheet data into a collection. So I have multiple collections for that excel.

Now I want to create a Parent collection and add all child collections to it. How can I achieve this in BluePrism.

Answer 1

You can resolve your issue by creating a single column of type collection for your main collection then each time you retrieve from collection use excel to 'add row'  and manipulate as you like