Blue Prism Product

 View Only
last person joined: 7 hours ago 

This community covers the core Blue Prism RPA product.

Expand all | Collapse all

How to Remove duplicate columns inside excel

Prateek Mehan

Prateek Mehan10-17-2017 02:06

  • 1.  How to Remove duplicate columns inside excel

    Posted 10-13-2017 13:23
    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??


  • 2.  Hello nitish,

    Posted 10-13-2017 13:45
    Hello nitish, You mean to say you have duplicate rows of same data or you have duplicate columns


  • 3.  I want to remove duplicate

    Posted 10-13-2017 15:53
    I want to remove duplicate rows of data for columns in excel sheet


  • 4.  Okay.

    Posted 10-13-2017 17:05
    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


  • 5.  Hi,

    Posted 10-16-2017 15:35
    Hi, I need little bit clearly can u elobarate it as much as u can..


  • 6.  Our you can do it manual in

    Posted 10-13-2017 18:27
    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 :)


  • 7.  You can use a macro to remove

    Posted 10-15-2017 12:10
    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.


  • 8.  Hi sudheer,

    Posted 10-16-2017 15:12
    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..


  • 9.  Hi sudheer,

    Posted 10-26-2017 17:19
    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.


  • 10.  Hi ,

    Posted 10-16-2017 13:51
    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


  • 11.  Use global send Keys: Alt+A+M

    Posted 10-17-2017 02:06
    Use global send Keys: Alt+A+M


  • 12.  Hi Prateek ,

    Posted 11-29-2017 17:09
    Hi Prateek , Can you please elaborate it that means how to pass shortcut key(Alt+A+M) in send keys


  • 13.  You can use OLEDB to get the

    Posted 12-04-2017 13:35
    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.


  • 14.  Use Global send keys Events…

    Posted 12-27-2017 17:15
    Use Global send keys Events to pass (Alt+A+M)  in the excel


Welcome to the Blue Prism RPA Product Community!

Whether you’re looking to manage a complex infrastructure, maintain security and compliance, bring new products to market faster, or gain operational speed and agility in an uncertain economy, Blue Prism delivers — with the flexibility you need to create the business you want. From deployment on-premise, through a cloud service provider or as SaaS, to a skillful and adaptable digital workforce that continually expands to meet your enterprise needs, you can gain enhanced operational insight and control while your people reclaim the time they need to focus on great work.

Product PageKnowledge BaseBlue Prism Training Offering
Product Research ProgramUpdates, Releases & Announcements

FAQs

Blue Prism is intelligent automation — business-developed, no-code automation that pushes the boundaries of robotic process automation (RPA) to deliver value across any business process in a connected enterprise.

A combination of RPA with expanded cognitive and AI capabilities, Blue Prism is different than other automation technology on the market. With one Blue Prism license, you gain instant access to an already AI equipped digital workforce, along with the tools you need to build and delegate automations. Click here for more information on Blue Prism and Intelligent Automation.
To learn more about how Blue Prism RPA can help your organization and how much it will cost to get started, please Contact our Sales department.
Blue Prism RPA can be downloaded from our customer portal. If you would like to consume or download any material it is necessary to create an account on the Portal. Once you have registered, you can access the download options for Blue Prism here.
Yes! Installed on your own machine and supported by our training materials and product documentation, you can use all the features of the full enterprise product for free with our Blue Prism Trial – giving you the opportunity to learn the basics before moving to a full production implementation. Click here for more information and to download the trial.
Yes! You can access our known issue list for Blue Prism from our Support Portal.
Regardless of your industry, Blue Prism’s Digital Workforce can adhere to strict governance and compliance standards without limiting productivity. Click here for more information on how your industry can benefit from Blue Prism.