Blue Prism Product

Hi, I have an excel sheet, in that i have a duplicate data, how can i remove duplicate data, i read excel sheet data in the form of collection, here i need to do compare the collections how i can do comparision??

Hello nitish, You mean to say you have duplicate rows of same data or you have duplicate columns

I want to remove duplicate rows of data for columns in excel sheet

Okay. You can use work queue to do that First you have to create a new queue enter key name field, the column name of your collection for eg Name or Id.We will remove remove duplicate data which contains same name or Id. Now use collection loops we will add collections data to queue one by one. Add Action stage in loop stage select business object work queue->select action -> Is Item In queue. create output data item which is flag type. Next Add decision Stage below action and check for flag if flag is true we will not add this data to queue just skip this and add link back to loop start. If flag is false for this add action to enter data in queue. here u need to use one temp collection where u store current row of collection. pass this collection as input to add queue. After all loop execution is done You can read queue data which contains your data which is not duplicate data. this is quite complex but it will help. If u don't understand anything reply but try to read it and implement i know its not efficient but it will give you desired output

Hi, I need little bit clearly can u elobarate it as much as u can..

Our you can do it manual in Excel. 1. Select the range of cells, or make sure that the active cell is in a table. 2. On the Data tab, in the Data Tools group, click Remove Duplicates. 3. Do one or more of the following: * Under Columns, select one or more columns. * To quickly select all columns, click Select All. * To quickly clear all columns, click Unselect All. 4. Click OK. (A message is displayed indicating how many duplicate values were removed and how many unique values remain, or if no duplicate values were removed.) 5. Click OK. You can easily make a program that does this, or do it manual if it is to hard :)

You can use a macro to remove duplicates:Use Action -> MS Excel VBO -> Run Macro Use the below macro: Sub RemoveDuplicates() Cells.RemoveDuplicates Columns:=Array(1, 2, 3) End Sub For this to work, first you have to Write the data to Macro work book and then after running the macro, copy the data back to a new collection to write it in new excel.

Hi sudheer, how to write data to macro work book and where to write below macro code, i mean to say can u elaborate clearly..

Hi sudheer, i am getting this exception: Internal : Could not execute code stage because exception thrown by code stage: Cannot run the macro 'Blueprism systest.xlsm'. The macro may not be available in this workbook or all macros may be disabled.

Hi , Inorder to remove the duplicates I did the following steps: 1. got the worksheet values into the collection.(this can be used by using ""get worksheet values as collection "" from action in Excel Business Object). 2. wrote a code stage in C# to remove duplicates as below: Datatable dt; dt=InputColl; // passing input coll as input parameter OutputColl=dt.DefaultView.ToTable(/*distinct*/true);// OutputColl as output parameter

Use global send Keys: Alt+A+M

Hi Prateek , Can you please elaborate it that means how to pass shortcut key(Alt+A+M) in send keys

You can use OLEDB to get the desired o/p. All you need is SQL Query which will return you the result in a collection. Write back this collection to the file. Sample Query be like: select min[ur_identifier_Header] from [SheetName$] group by [Header1], [Header2] so on..... First u need to set connection to excel sheet using OLEDB VBO. That link u can have in the portal. Search for OLEDB.

Use Global send keys Events to pass (Alt+A+M)  in the excel