Search results

You need first merge the two collections (emp1 + emp2) and use the merged coll (for example emp3) in the loop.. all data will be in one collection, so you can get the duplications now

You can use loop, save data from first row into data item, and then ask if it is equal to another row.. if yes -> write into new sheet in column b and you will do this for every single row.. it’s only one decision and one calculation stage inside the loop :)

Can you upload screenshot of the two merged excel files and show us some case for example please ? :)

Hi, You can get the excel sheets (1,2) as collections into BluePrism and loop through the collections to find your uniqe value.. Then you will just write it into the 3rd new excel worksheet. Let me know if you get it. :)

I was replying to this post “I just tried this, but I got "Failed to copy worksheet: The given key was not present in the dictionary."” but i missclicked probably. Anyway it works for me now somehow, but idk how i fixed it.. :)

Hi, did you resolve the problem somehow ?