How to loop in excel vbo

[gautham]

I am getting my work sheet as collection and now I want to take the data of the 2 nd row by looping , how to achieve this

 

[rpame]

I am getting my work sheet as collection and now I want to take the data of the 2 nd row by looping , how to achieve this

What you need to do are to use the Loop action that you will find in the Tools area of Blue Prism.

 

[Sachin_Kharmale]

Use Blue Prism Loop Stage to Looping Collection
manage row count data item counter when it will become 2 then copy data from collection
[Collection.Filed Name] to Copy data from collection.

Basically flow will look like

View attachment 1559116572797.png

Fig- Basic flow to copy Second row from Collection
Best,
Sachin