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 Mata42,
Which error are you trying to resolve?
If you are facing the index error then it is fixed by the solution mentioned in Post #2.
If it is something else you can detail out the issue.
Hi,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.
Can you upload screenshot of the two merged excel files and show us some case for example please ?Hi,
I am able to write the data of excel1,excel2 into excel3. In excel 3 I have some duplicate numbers, I not able to get the logic of copy the duplicate and paste in 'B' column.
Here, below are the steps I followed:
1.Create Instance->Open excel1->Getdata(Output-data1collection)->Open excel2->Getdata(Output-data2collection)-> Close instance->
2.Create Instance-> Create new workbook->opennewworkbook->write the data1->write data2->save workbook->close instance
In step 2, after write data2, I need to copy the duplicate numbers and paste in paste in 'B' column.
Can you help me!
In emp_new sheet, the data which was from emp1, emp2 excel sheets. I am able to paste in emp_new.xl. I need to find out duplicates from A column, and put in to B column.Can you upload screenshot of the two merged excel files and show us some case for example please ?
Hi rpabp, no it is nothing like a basic question. The links I have provided you already has everything you need to find the unique values from a collection/excel. It's good to see that Mata42 is assisting you further. Regarding Tutorials, if you are looking for something specifically for excel then you will need to do a web search and find the relevant ones. For overall Blue Prism tutorials, the one from Busy Ping is good to go.Hi VJR,
Thank you for giving your answer, I know this is very basic question to you.
I am very new to RPA - BP. If you can provide any tutorial links, it would be very helpful to me.
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 loopIn emp_new sheet, the data which was from emp1, emp2 excel sheets. I am able to paste in emp_new.xl. I need to find out duplicates from A column, and put in to B column.
Confusion, when I use loop , I need to select collection from dropdown right. But it was not creating any collection while writing the data to excel3(I am using Write collection action from drop down).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