topic Hi, in Product Forum

How to Remove duplicate columns inside excel

Venkata_NitishM — Fri, 13 Oct 2017 12:23:00 GMT

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,

SurajJadhav — Fri, 13 Oct 2017 12:45:00 GMT

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

I want to remove duplicate

Venkata_NitishM — Fri, 13 Oct 2017 14:53:00 GMT

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

Okay.

SurajJadhav — Fri, 13 Oct 2017 16:05:00 GMT

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

Our you can do it manual in

Christer_Tellefsen — Fri, 13 Oct 2017 17:27:00 GMT

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

SudheerReddy — Sun, 15 Oct 2017 11:10:00 GMT

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 ,

RathishKN1 — Mon, 16 Oct 2017 12:51:00 GMT

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

Hi sudheer,

Venkata_NitishM — Mon, 16 Oct 2017 14:12:00 GMT

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,

Venkata_NitishM — Mon, 16 Oct 2017 14:35:00 GMT

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

Use global send Keys: Alt+A+M

PrateekMehan — Tue, 17 Oct 2017 01:06:00 GMT

Use global send Keys: Alt+A+M

Hi sudheer,

Venkata_NitishM — Thu, 26 Oct 2017 16:19:00 GMT

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 Prateek ,

ChandraAddepall — Wed, 29 Nov 2017 17:09:00 GMT

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

JivankumarKedar — Mon, 04 Dec 2017 13:35:00 GMT

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…

parthasarathy — Wed, 27 Dec 2017 17:15:00 GMT

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