How to populate Collection through the lopp

[Anonymous]

Hi, I am trying to read data from 2 excel (Master/Child) and after the same comparing the records. Once the record is matching I like to put it in a new collection created. Here till the record matching is done within the loop. Now my aim is to create a final collection and once done will write it into the excel after few basic operation. But I am stuck with the process to append records in a new Blank collection (Field Names are already created in the new collection). Any help regarding the same.

[Denis__Dennehy]

Hello, You should have a mentor available to you as part of your training path to raise questions such as this. If you do not have a mentor availalbe please raise that as an issue with your RPA manager. To add a row to a collection you use the 'Add Row' action in the internal collections object. You can set data on the current row using a calculation or multi-calculation stage.