Solved Looping the collection of 10 records in Excel sheet using the Blue Prism

[Devendhar]

I have excel file that has 50 records. I would like to take only 10 records and save to collection stage and then looping for remaining records .Could you please help me to resolved the issue..

 

[RDawson9]

Hi @Devendhar

I'm afraid I don't fully understand your question. You want to convert the first 10 records into a collection but it's not clear what you wish to do with the other 40?

Rob

 

[Devendhar]

@RDawson9 sorry for the confusion!!

This is the scenario -

1. I have a excel sheet which has for example : 100 records.
2. I also have an application which can process only 20 records at a time.

I'm trying to automate this process using Blueprism, where the application should automatically pick only 20 records from excel at one time, does the processing. then the application should go back to excel, pick another 20 records and process them. - should work as a loop.

Regards,
Devendhar

 

[anisjolly]

You could copy all of the records from Excel to a Data collection. You then could copy one row from the Source Data Collection to a Target Data Collection. As you copy each row, use an incremental count to check if you've copied across 20 rows and remove the row from the source Data Collection. Do this 20 times and then process your Target Data Collection.

Or you could use the Utility - Collection Manipulation object (Copy Rows) to achieve a similar functionality and copy 20 rows at a time?

 

[Devendhar]

@anisjolly Thanks for your response !!

its working fine now .

Regards,
Devendhar