• RELEVANCY SCORE 3.96

    DB:3.96:Delete Duplication In Infoset Query Sq02 Sq01 k8





    i use a join which give many entrites same i want to remove all duplicates.

    DB:3.96:Delete Duplication In Infoset Query Sq02 Sq01 k8


    i use a join which give many entrites same i want to remove all duplicates.

  • RELEVANCY SCORE 3.76

    DB:3.76:How To Remove Duplicates In Sas 4.3 Eg m3





    Hello all

    Got a query on how to remove dulicates while using SAS 4.3 EG

    Any pointers would be of help.

    Thanks

    Sundari

    DB:3.76:How To Remove Duplicates In Sas 4.3 Eg m3


    By chance, I just added a blog post with a simplified example of what EmilyC describes.

    HAVING (clause) fun with SAS Enterprise Guide - The SAS Dummy

    Chris

  • RELEVANCY SCORE 3.73

    DB:3.73:Duplicates Query az




    I am running a Find Duplicates query from a button. Is there anyway in which to:

    1. Have the query display only if a duplicate was found
    2. Display a message box if duplicates are found (purpose of the message box would be to provide instructions on how to resolve the duplicate issue)

  • RELEVANCY SCORE 3.67

    DB:3.67:Possible Bug In Duplicates Removed fm


    The duplicates remove method (list.distinct) appears to be case-sensitive. Is this the expected behaviour? If so, is there a way to make the method case-insensitive?
    Steps to follow:
    1) Create the following list in Excel and create a query based around it -
    Thank You
    Thank You
    Hello There
    hello there
    Excuse ME
    Excuse me
    2) In Filter Shape, click remove duplicates
    3) Result - The following list remains
    Thank You
    Hello There
    hello there
    Excuse ME
    Excuse me
    4) Expected Result (This is also what I get when I use the remove duplicates feature from the data tab) -

    Hello There

    Excuse Me

    Thank You

    I am running the 32-bit Excel 2013.
    Thanks!!

    DB:3.67:Possible Bug In Duplicates Removed fm

    Thanks Alejandro.
    I tried your method, it works. Because it uses one fewer step, it is also probably faster and uses less memory.

  • RELEVANCY SCORE 3.67

    DB:3.67:Removing Duplicates Without Deleting Rows Excel 2003 ax


    Hi
    How do I remove duplicates in Column A without deleting rows

    Number
    Desc

    123
    Apple

    123
    Pear

    12
    Orange

    456
    Grapes

    456
    Apple

    456
    Pear

    End result

    Number
    Desc

    123
    Apple

    Pear

    12
    Orange

    456
    Grapes

    Apple

    Pear

    DB:3.67:Removing Duplicates Without Deleting Rows Excel 2003 ax

    Max has answered your question.......as you acknowledge, "it works perfectly". If you follow his instructions completely you will see that it will work on 1000 rows almost as quickly as it does on the six in your sample.A macro is not really needed in
    this case.
    Vaya con Dios,
    Chuck, CABGx3

  • RELEVANCY SCORE 3.59

    DB:3.59:How To Remove Duplicates In String j8


    how to remove duplicates in string like in system it should remove s and

    give me sytem

    Thanks in Advance

    DB:3.59:How To Remove Duplicates In String j8

    AJ, It should disply only MDY but its displaying only D check it out

  • RELEVANCY SCORE 3.52

    DB:3.52:Ht2905 How Does One Remove Duplicates In Windows Itunes 11? fa


    Just upgraded to 11. No "show duplicates" option anymore? What gives? Maybe it's hidden...

    DB:3.52:Ht2905 How Does One Remove Duplicates In Windows Itunes 11? fa

    Just upgraded to 11. No "show duplicates" option anymore? What gives? Maybe it's hidden...

  • RELEVANCY SCORE 3.52

    DB:3.52:Remove Duplicates sx


    I have text values in J1 thru J8:

  • RELEVANCY SCORE 3.50

    DB:3.50:Leading And Trailing Spaces 3k


    I am having a issue with Leading and Trailing Spaces. I have values that are being showed duplicates because they have leading, Trailing or any unoticiable ascii characters. I want to ensure that i remove them so the duplicates values can be handled.
    I tried using in Query but i still had no success.

    thoguhts ?
    SELECT Ltrim(Rtrim(FTA.BeforeValue)) BeforeValue, LEN(Ltrim(Rtrim(FTA.BeforeValue)))
    FROM Fact_TicketAudit AS FTA INNER JOIN

    Dim_Auditfield AS AF ON FTA.AuditFieldID = AF.AuditFieldID
    Where (AF.AuditFieldID = (10002))

    Group by Ltrim(Rtrim(FTA.BeforeValue)), LEN(Ltrim(Rtrim(FTA.BeforeValue)))
    Order by Ltrim(Rtrim(FTA.BeforeValue))

    DB:3.50:Leading And Trailing Spaces 3k


    I tried SEVERAL times to click 'Propose As Answer' for Naomi's answer. I get an error message every time. I tried in 2 browsers; I logged out and logged in again; I just keep getting error messages here. Oh well. That would be my
    proposed answer.
    Great job, now and always, Naomi!!

    Ryan Shuell

    Thanks for reporting.Kalman Toth SQL SERVER 2012 BI TRAINING
    New Book: Beginner Database Design & SQL
    Programming Using Microsoft SQL Server 2012

  • RELEVANCY SCORE 3.46

    DB:3.46:Remove Duplicates E-Mail Received In Windows Live Mail 7j


    I have recently had to reinstall windows 7. I use windows live essentials e-mail tool. Downloading the e-mail using POP from my g mail server, I have received about 1000 duplicates mails. Gmail is fixed now to only deliver new e-mails, but how to remove
    the duplicates.
    This is a one off problem so I do not want to buy a specific tool, but Is there a way to delete duplicates within live mail?

    DB:3.46:Remove Duplicates E-Mail Received In Windows Live Mail 7j

    Hello,

    It is possible that you set up your account twice in Windows Live Mail. To isolate the possible causes of your issue, please back up your files, then delete all the account configured and then reconfigure your account in Windows Live Mail. Here are the steps:

    1. Before removing an account, check that the messages you want saved are available when you sign in to the web version. For example, if you want to remove a Yahoo! account, sign in at
    http://mail.yahoo.com and verify that your messages are there. If some of your messages are available only in Windows Live Mail, export your messages before removing the account.
    See How do I import and export email, contacts, and calendars with Windows Live Mail?

    2. Right-click the account you want to remove, and then click
    Remove account.
    3. Click Yes to confirm.
    4. Reconfigure your account in Windows Live Mail.

    Thanks!

  • RELEVANCY SCORE 3.42

    DB:3.42:Remove Duplicates From Union Query da


    Hi!! I need help removing duplicates from my union query. I am SQL illiterate so just creating the union query took most of my brain power... what statement am I missing? Thanks in advance!

    SELECT * FROM [SEARCH BY INCIDENT]
    UNION ALL
    SELECT * FROM [SEARCH BY TEXT]
    UNION ALL
    SELECT * FROM [sEARCH BY DATE]
    UNION ALL
    SELECT * FROM [SEARCH BY CIO OR PIA]
    UNION ALL
    SELECT * FROM [SEARCH BY PROBLEM #]
    UNION ALL
    SELECT * FROM [SEARCH BY IMPACT]

  • RELEVANCY SCORE 3.41

    DB:3.41:Re: Excluding Duplicates In An Update Query. cx


    post (formatted) EXPLAIN PLAN

    DB:3.41:Re: Excluding Duplicates In An Update Query. cx

    Results of SQL

    CDM_CONSUMER010/DEC/11
    GEN_BITHISTTABLE239351503/DEC/11

    SQL

    explain plan for
    update CDM_CONSUMER c
    set csdate = (
    select BI_HIST_DATE
    from (
    select BI_INST_CODE, max(BI_HIST_DATE) BI_HIST_DATE
    from GEN_BITHISTTABLE
    group by BI_INST_CODE
    ) g
    where c.CINSTALL = g.BI_INST_CODE
    )

  • RELEVANCY SCORE 3.41

    DB:3.41:Remove Duplicates 3p


    I have a spreadsheet that contains duplicate numbers in column A. To save me having to go down the list manually can anyone give me the formula to find any duplicates?

    DB:3.41:Remove Duplicates 3p

    I have a spreadsheet that contains duplicate numbers in column A. To save me having to go down the list manually can anyone give me the formula to find any duplicates?

    Hello,
    Another two possible approaches:
    1. You can apply a conditional format: Select A1, then whole column A, go to conditional format and apply formula
    =COUNTIF(A:A,A1)1
    with some convenient format (red background, for example).
    2. http://sulprobil.com/html/lfreq.html
    Regards,
    Bernd

    www.sulprobil.com

  • RELEVANCY SCORE 3.41

    DB:3.41:Duplicates In Itunes 3s


    I have more than 22'000 songs, many of duplicates. how can I remove those dups easily, without having to go through the whole list in a painstaking way. thanks for your help. Barbara

    DB:3.41:Duplicates In Itunes 3s

    I have run the script but nothing really happened ? Where should the dups show ? and once they show how can I remove them at once ?
    Thanks again for your feedback.

  • RELEVANCY SCORE 3.39

    DB:3.39:Help Remove Duplicates as


    I have just moved from windows to iMac. Followed instructions to transfer my library using the ipod and all seemed well. However, I now seem to have lots of duplicates in the itunes and it says it cannot load all onto the ipod because there is not enough room. Is there a way of getting rid of duplicates or do I have to start again?

    DB:3.39:Help Remove Duplicates as

    thanks, looks like that may have solved it. I just reset the ipod to get my space back. so hopefully all well once it's finished synching.

  • RELEVANCY SCORE 3.37

    DB:3.37:How To Remove Duplicates From A Flat File Without Using Sorter And Aggregator Transformations z1



    Hi All,

    Some body asked this question in ITtools site.I am expecting different ways of doing this.

    How to remove duplicate through mapping? a b c a a b d

    Source is flat file, remove duplicates without using sorter and aggregator transformation in Informatica.

    DB:3.37:How To Remove Duplicates From A Flat File Without Using Sorter And Aggregator Transformations z1


    I think Java will be another option .. need to explore it more .. never tried it ...

  • RELEVANCY SCORE 3.37

    DB:3.37:Remove Duplicates In Excel Between Columns xf


    Hello. I have two columns of names. I need to subtract duplicates between the two columns (Column A minus Column B). This is for Office Professional 2010. If anyone has an answer, I would be grateful.

    Amy

    DB:3.37:Remove Duplicates In Excel Between Columns xf

    Hi,

    Please clarify your question. Give the data set and expected output

  • RELEVANCY SCORE 3.33

    DB:3.33:Access 2007 - How To Get A Query With No Duplicates 9p


    I have multiple data in a query and I only want one of each. How do I this?

  • RELEVANCY SCORE 3.32

    DB:3.32:Duplicates In Itunes Folder But Not Itunes x7


    Hi,Through Spotify I figured out that my music library on my Mac contains duplicates of many of my songs. Since this is a problem in the User Music iTunes folder, the usual "Find duplicates" won't help. I have over 5,000 songs, so is there any way to isolate and remove duplicates within the folder?Thanks!

    DB:3.32:Duplicates In Itunes Folder But Not Itunes x7

    Use File Add Folder to Library to add the iTunes Media folder to the library.Existing tracks will be ignored, new tracks will be added.Use the Option+File Show Exact Duplicates feature to show exact duplicates.Sort the list on Date Added.Delete the duplicates added today.tt2

  • RELEVANCY SCORE 3.32

    DB:3.32:Duplicates In Contextual Menu 7f


    When I right-click on a file to invoke a contextual menu, I see duplicates of apps like Preview, Safari, QuickTime. I first noticed this when I set up my new MacBook during which I transferred all my settings from my iBook. I never saw dupes when using contextual menus on my iBook. Is there a way I can remove the duplicates? Takes up a lot of space and it drives me nuts.

    DB:3.32:Duplicates In Contextual Menu 7f

    Gosh. That was SO easy! Thank you both, Templeton and Dr. Smoke. I always appreciate learning new things here in the forums.

  • RELEVANCY SCORE 3.31

    DB:3.31:When Deleting Duplicates, How Do You Keep The Duplicates In A File Or On The Spreadsheet x8


    WHEN YOU HIT REMOVE DUPLICATES, THEY JUST DISAPPEAR AND I NEED TO SAVE THEM. ALSO I TRIED SORTING USING ADVANCED AND IT PULLS THE UNIQUES OUT AND LEAVES THE ORIGINAL DOCUMENT INTACT. I NEED THE DUPLICATES PULLED OUT SO I CAN HAVE THEM SOLELY IN A DIFFERENT
    FILE.

    DB:3.31:When Deleting Duplicates, How Do You Keep The Duplicates In A File Or On The Spreadsheet x8

    Sorry, looks like you wanted the reverse situation, ieextract duplicates
    Just tweak the criteria col B formula in the earlier construct to flag duplicates instead of uniques ..

    Here's a formulas way todynamically extract duplicates from a source column list into another column
    Source data is assumed running in A2 down
    In B2: =IF(A2="","",IF(COUNTIF(A$2:A2,A2)1,ROW(),""))
    In C2: =IF(ROWS($1:1)COUNT(B:B),"",INDEX(A:A,SMALL(B:B,ROWS($1:1))))
    Copy B2:C2 down to cover the max expected extent of source data in col A, eg down to C100
    Hide away/minimize col B. Col C dynamically returns the list ofduplicate itemsfromcol A, with results all neatly bunched at the top.

  • RELEVANCY SCORE 3.30

    DB:3.30:How Do I Remove Multiple Duplicates Of A Song In Media Payer 3m


    I;m running Windows eight and using Media player some how my songs got duplicated , How can I remove these extra copies without deleting the complete Album

    DB:3.30:How Do I Remove Multiple Duplicates Of A Song In Media Payer 3m

    I Thank You for your fast response to my Media Player issues. I'm sure not to happy with the set up of Windows eight, on my new computer. Wish I had kept my old computer running Windows Seven. I never had these issues with it. Some good suggestions stay
    away from Windows Eight, Iv'e been told Windows Eight is a failure and Microsoft is coming out in about a year with Windows Blue? My new computer is nothing more then a computer Vending machine. Again thanks for your help with my Media Player issues ,very
    much appreciated. R.White form Ontario Canada.

  • RELEVANCY SCORE 3.29

    DB:3.29:Remove Duplicate Rows From A Table ja


     
    Hi guys
    I have been using SQL server 2005. I have got a huge table with about 1 million rows.
    Problem is this table has got duplicate rows in lot of places. I need to remove the these duplicates. Is there an easy way to do that??
    Is there a query in SQL to remove duplicate rows???
     
     
    thanks
    Mita

    DB:3.29:Remove Duplicate Rows From A Table ja

    Hi,
    refer below threads discussing same topic
    http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=3632
    http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=18529
    http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=14484
    http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=13882
    Hemantgiri S. Goswami

  • RELEVANCY SCORE 3.29

    DB:3.29:Duplicate Loops sx


    I not sure how I got a bunch of duplicate loops in my GB, but I would like to remove the duplicates. Any ideas on how to do this besides using spotlight to find them one at a time. I am hoping there is a way to do a "show duplicates" like in iTunes.

    DB:3.29:Duplicate Loops sx

    I not sure how I got a bunch of duplicate loops in my GB, but I would like to remove the duplicates. Any ideas on how to do this besides using spotlight to find them one at a time. I am hoping there is a way to do a "show duplicates" like in iTunes.

  • RELEVANCY SCORE 3.29

    DB:3.29:Reverse Duplicates Ii Expressions 38


    How do we remove reverse duplicates in Qlikview?

    I have a table that contains rows like AB,AC,AD and BA,BC,BD.
    COL 1COL2ABACADBACADA
    The following is a description and solution for the problem in SQL. I am just not able to figure out how to do this in QlikView?
    http://stackoverflow.com/questions/13041802/remove-reverse-duplicates-from-an-sql-query

    The problem has already been solved using scripting. Reverse Duplicates
    My Question is, could we achieve the same using QlikView chart expressions?

    Regards,
    Gokul

    DB:3.29:Reverse Duplicates Ii Expressions 38


    Hi Gokul,

    Handling this in set analysis is very difficult what I can suggest is arrive a flag in script and then use set analysis to exclude the duplicates, try like below

    Temp:
    LOAD *,Ord(Pos1) + Ord(Pos2) as Value;
    LOAD * Inline [
    Pos1,Pos2
    A,B
    A,C
    A,D
    B,A
    C,A
    D,A
    ];

    Data:
    LOAD
    *,
    If(Peek(Value) Value, 0, 1) AS IsDuplicate
    RESIDENT Temp
    ORDER BY Value;

    DROP TABLE Temp;

    Now in chart try below expressions

    Count({IsDuplicate={0}} POS1)

    Hope this helps you.

    Regards,
    Jagan.

  • RELEVANCY SCORE 3.29

    DB:3.29:How To Remove Duplicates In Sap Query 73



    Dear Frns,

    I created a simple SAP query with quickviewer by table join option.

    tables are MAST STPO.

    Link is only STLNR.

    I am getting a duplicate extra line with same data.

    Can anyone suggest me how it happened.

    Is there anyway to remove these duplicate lines.

    pl suggest

    DB:3.29:How To Remove Duplicates In Sap Query 73


    Dear sathish,

    i am not finding any code tab in quick viewer( SQVI).

    The code tab is available only in SQ02.

    When creating queries we will not store in any internal table.

    so pl guide me what kind of code I can write to remove the duplicates.

  • RELEVANCY SCORE 3.29

    DB:3.29:Write A Duplicates Query 17


    I understand how to write a duplicates query, however, I have a twist to this need. I have numerous records wherefield1 contains duplicate values. In those duplicate records, field2 may or may not have a value. I want to find records
    where at least one of the duplicates has field2 being null, yet I want to see the related duplicates as well.
    Thanks!

    DB:3.29:Write A Duplicates Query 17

    Your solution seems to work nicely, however, your first query needed some tuning.

    Thank you for your effort and help.

  • RELEVANCY SCORE 3.29

    DB:3.29:Only Display Form If Duplicates Detected d3


    I have table which could possibly have duplicate data in field "my". I can run a query to find these records no problems.The 'duplicatequery', which just matches data in the 'my' field on a form is run when the next form (displaying duplicate data) is
    opened.

    What I would like to do is to not open the 'duplicates form' if there is no duplicates returned from the query.

    Stuck.

    Regards All

  • RELEVANCY SCORE 3.28

    DB:3.28:Itune Library Duplicates 9m


    I have noticed many "postings" about duplicates being created in the iTune library with many suggestions about how to remove them (without any good permanent solutions). What I don't understand why does iTunes allow duplicates in the first place?

    My second question is "why are the duplicates being created?". Is there a setting that can be selected to keep this from happening in the future?

    DB:3.28:Itune Library Duplicates 9m

    I have noticed many "postings" about duplicates being created in the iTune library with many suggestions about how to remove them (without any good permanent solutions). What I don't understand why does iTunes allow duplicates in the first place?

    My second question is "why are the duplicates being created?". Is there a setting that can be selected to keep this from happening in the future?

  • RELEVANCY SCORE 3.28

    DB:3.28:How To Write This Query 9m


    hi ,

    i have the following 2 tables
    table1
    createdate,
    id ,
    desc,
    remarks

    table2
    id ,
    starttime
    endtime

    how can i in my query get all records from table1 (w/o using DISTINCT)
    my current query
    select DISTINCT a.* from table1 A , table2 B
    where (a.createdate b.starttime OR
    a.createdate b.endtime)
    and a.id = b.idmy query above will return duplicates as table1 and table2 is a many-to-1 relation

    why i want to remove the DISTINCT is because it took very long 1hrs to return some results but if i remove the DISTINCT it returns instantly

    tks rdgs

  • RELEVANCY SCORE 3.27

    DB:3.27:Comparing Clob Columns In Two Tables as


    I need to copy the clob data from one table to another. However, I need to remove duplicates while doing so. When I run the following query, it loads all of the rows, whether they are duplicates or not.

    INSERT INTO L_COMMENTS
    SELECT comments_key.NEXTVAL, 'ASSOCIATECOMMENTS', ASSOCIATECOMMENTS
    FROM TABLE1 A
    WHERE ASSOCIATECOMMENTS IS NOT NULL
    AND NOT EXISTS
    (select 1
    from L_COMMENTS C
    where COMMENT_TYPE = 'ASSOCIATECOMMENTS'
    AND dbms_lob.compare(C.COMMENTS, A.ASSOCIATECOMMENTS) = 0)

    Any idea on how to do this load? I have several similar loads to do.

    DB:3.27:Comparing Clob Columns In Two Tables as

    If I did that, for any column that has a duplicate, neither one would be included.

  • RELEVANCY SCORE 3.27

    DB:3.27:Add Duplicates Option Opposite Of Remove Duplicates--- Does It Exist j7


    In excel, there is a remove duplicates option, but is there a duplicate option to specify # of times (like BIG numbers, 800-900, where copy/paste is inefficient)

    DB:3.27:Add Duplicates Option Opposite Of Remove Duplicates--- Does It Exist j7

    But... if you have one column of data and you want to separate that out into separate column for each number, you could do something like this:
    With your long list in column A, place the unique numbers in row 1, e.g.:
    C1: 5
    D1: 7
    E1: 9
    F1:15
    G1: 16
    (You can use paste special to transpose the list of unique numbers).
    Now in C2 enter the following formula:
    =IF(COUNTIF($A:$A,C$1)=ROW(),C$1,NA())
    Drag this formula across to G2 then down as far as required (you could use the GoTo and Pastemethod I described previously).
    If you don't want to see the #N/A's then you could use:
    =IF(COUNTIF($A:$A,C$1)=ROW(),C$1,"")
    instead, but that may cause issues due to "" being text.

    Finally, just to check, you are aware of the
    PERCENTILE function?
    Cheers
    Rich

  • RELEVANCY SCORE 3.26

    DB:3.26:How To Find And Remove Duplicates a9


    How do I find and delete duplicates in iphoto? Please Help.

    DB:3.26:How To Find And Remove Duplicates a9

    I've only used the demo in a limited way on a test library. The app that seems to be the very effective is PhotoSweeper as it compares the bit map or histogram of the images and not the metadata: Re: i photo has duplicated many photos, how do I find the duplicates and remove them?

  • RELEVANCY SCORE 3.25

    DB:3.25:I Am Seeing Duplicate Values In The Bdssa Report. zp



    When I generatred a report in BDSSA, I am seeing duplicates entries for the same server. Is there are way to remove these duplicates from the reports.

    DB:3.25:I Am Seeing Duplicate Values In The Bdssa Report. zp


    Hi Mike

    This filter should be available under 'Server' object in the left pane in query studio. Look for a folder by name 'Common Filters' or something similar. 'Server Is Latest Version' should be available in the common filters.

    Let me know if you are unable to find it. I can try and get a screenshot.

    Thanks

    Naveen

  • RELEVANCY SCORE 3.23

    DB:3.23:Query To Find The Alternate Row From A Table And Also Query kf


    Give me the query that fetches

    1. alternate row from a table

    and also query

    2. that constraints a table to contain duplicates with Unique values.i.e. that table has already duplicate values. we need to alter the table add a constraint that the column no way receives such duplicates here after.

    Pls Reply as these questitions were framed in an interview to my friend.

  • RELEVANCY SCORE 3.23

    DB:3.23:Remove Duplicates In A Query 8j


    I have two columns...

    The first columns have machine names and the second column is the user who owns that machines

    I would like to run a query that deletes all the dups...keeping only one of them.
    So if you have four machine names and four of the same user names. I want it to find all the machine names and delete all except for one.

    How do I do that?

    I did a query wizard "find match" but it wont keep one of each.

    DB:3.23:Remove Duplicates In A Query 8j

    Duh! I was naming the query not the table. Back to basics! Thank you so much!

  • RELEVANCY SCORE 3.23

    DB:3.23:Remove Duplicates In Lov. 87


    Hello,

    I'm using JDeveloper 11.1.1.3. I have a list of value that displays an attribute from a VO. In this VO i have many values that are repeated. I'm trying to remove the duplicates using the 'DISTINCT' clause in the query of the VO. But it's not working. Any one has an idea on what might be the problem?

    My query in the VO is this:

    SELECT DISTINCT
    AdministrationCirculars.NBR,
    AdministrationCirculars.REFERENCE_NBR,
    AdministrationCirculars.FILENAME,
    AdministrationCirculars.ISSUEDATE,
    AdministrationCirculars.SIGNATURE,
    AdministrationCirculars.SUBJECT
    FROM ADMINISTRATION_CIRCULARS AdministrationCircularsThanks,

    Mohamed.

  • RELEVANCY SCORE 3.21

    DB:3.21:Remove Duplicates In A Listbox m7


    i have a listbox with the following items (im using C#)
    Bill Gates
    Barack Obama
    Brad Pitt
    Barack Obama
    Barack Obama
    Jet Li
    Bill Gates
    I need to display it like this
    Barack Obama = 3
    Bill Gates = 2
    Brad Pitt = 1
    Jet Li = 1
    Pls advise. Thanks. I already do some google but no luck.

    cal_bonjovi
    I forgot to mention that i cannot use Query Expressions

  • RELEVANCY SCORE 3.21

    DB:3.21:I Want To Remove Duplicates And Triplicates From Windows Photo Gallery 1d



    In windows photo gallery I have somehow managed to have many duplicates and even triplicates of photos - is there an easy way to remove them without having to delete each one individually. For example ITunes has a feature which shows duplicate tracks
    and a simple 1 clickremovaloption

  • RELEVANCY SCORE 3.20

    DB:3.20:Remove Duplicates? jj


    I accidentally performed a rule that duplicated all of the email in one of my Mailboxes 5 times...is there any way to remove ALL exact duplicates with a function?

    DB:3.20:Remove Duplicates? jj

    I accidentally performed a rule that duplicated all of the email in one of my Mailboxes 5 times...is there any way to remove ALL exact duplicates with a function?

  • RELEVANCY SCORE 3.20

    DB:3.20:Query To Return Duplicate Data c1


    Hello,

    Is there a way to get the number of duplicates in a given query, based on certain criteria? Please provide the code if this is technically feasible to do.

    DB:3.20:Query To Return Duplicate Data c1

    If you meant to say to identify the dup rows on a given table/column. Then there are many ways to apprach. Here is one approach

    create table t1(a number, b varchar2(2));

    insert into t1 values(1,'A');
    insert into t1 values(1,'B');
    insert into t1 values(2,'C');
    insert into t1 values(3,'D');

    -- Idendify the rows with dup val on column "a" from t1

    select *
    from t1 t1_outer
    where rowid (select min(rowid )
    from t1
    where t1.a = t1_outer.a);

  • RELEVANCY SCORE 3.20

    DB:3.20:Excel Crashes Every Time I Remove Duplicates... 79


    Every time I remove duplicates from a column my Excel crashes, any suggestion of how to fix this short of never removing duplicates?

    DB:3.20:Excel Crashes Every Time I Remove Duplicates... 79

    What update level of Excel and Mac OS are you using? To find out the update level of Excel, go to the Excel menu and choose About Excel.

    If the version is not 14.3.0, then go to Excel's Help menu and choose Check for Updates to launch the Autoupdate Utility.

  • RELEVANCY SCORE 3.19

    DB:3.19:Duplicates In Combo Box p3


    I am creating a data entry form to update an "invoice" table. The "City" field is required to be a combo box and must contain all the cities listed in the "invoice table". This is fine, but it did not list them in alphabetical order so to overcome this
    I have created a query which lists all the cities in alphabetical order and bound the combo box to this query. This works fine, except there are duplicates because more than one person lives in each town. How do I remove the duplicates from the combo box?

    DB:3.19:Duplicates In Combo Box p3

    Thanks for the help, this database is only a project for study so the state is irrelevant.

    First, when asking for help with schoolwork, you should mention that it is schoolwork up front. This could change the way we respond.

  • RELEVANCY SCORE 3.19

    DB:3.19:Sort And Remove Duplicates In Xsl fz


    How can I sort and remove duplicates in XSL?

    DB:3.19:Sort And Remove Duplicates In Xsl fz

    We have a publication that uses the following xsl. Every chapter has a number, so it first sorts them in ascending order. Then, it removes any duplicates in the second for-each loop, so that chapter titles will only display one time, no matter how many documents are within that chapter.xsl:for-each select="xalan:nodeset($result)/root/Row"xsl:sort select=".//chapter/@number" data-type="number" order="ascending" /xsl:for-each select=".//chapter[not(.=following::chapter)]"

  • RELEVANCY SCORE 3.19

    DB:3.19:Remove Duplicates From Query aj


    Hello!
    i have query that filters lines of Invoices where Product has been mentioned and it brings back results such as:
    Invoice 1
    Invoice 1
    Invoice 1
    Invoice 2
    Invoice 2....

    while this works in correct manner, it would be nmuch better if it would give out list without duplicates, like
    Invoice 1
    Invoice 2

    is this possible to achieve in simple manner, without WCF RIA service?

    THANX!

    DB:3.19:Remove Duplicates From Query aj

    I don't completely understand the schema of your tables, but what you should do is write a query over the INVOICE entity set instead of the INVOICE_LINE entity set. Add some parameters to represent the data that you want to filter on andthen write
    code in the PreprocessQuery method of the query to filter a particular INVOICE instance depending on if it contains a related INVOICE_LINE instance that conforms to the constraints you need. For example:
    partial void Query1_PreprocessQuery(string Article, ref IQueryableInvoice query)
    {
    query = query.Where(invoice = invoice.InvoiceItems.Any(item = item.Article.Equals(Article, StringComparison.Ordinal)));
    }Justin Anderson, LightSwitch Development Team

  • RELEVANCY SCORE 3.19

    DB:3.19:Re: Help Required In Refining A Query cj


    Yes, i would like to have the count.
    But as per the query, I would like to eliminate the duplicates, while calculating the count itself.

    DB:3.19:Re: Help Required In Refining A Query cj

    True, i agree.
    However, i think i was able to get closer to the solution with the following query :

    select C1 AS No_Of_Completed_WOs, C2 as Wos_with_Soft_Fail, (C1-C2) as Completed_Wos,C3 as Failed_Wos,C4 as TimedOut_Wos from (select (CASE WHEN T1.EXTSYS_ID IS NULL THEN 'NULL'
    ELSE T1.EXTSYS_ID END),
    count(case when T1.WO_STAT=104 AND T1.XACTION_TYPE like '%Completion%' then T1.WO_STAT end ) as C1,
    count(case when T1.WO_STAT=104 AND XACTION_TYPE like '%Soft Error%' then T1.WO_STAT end ) AS C2,
    count(case when T1.WO_STAT=253 then T1.WO_STAT end ) AS C3,
    count(case when T1.WO_STAT=251 then T1.WO_STAT end ) AS C4
    from ( select distinct TBL_WRK_ORD.WO_STAT,XACTION_TYPE,TBL_WO_EVENT_QUEUE.EXTSYS_ID from TBL_WRK_ORD,TBL_WO_EVENT_QUEUE WHERE TBL_WRK_ORD.WO_ID=TBL_WO_EVENT_QUEUE.WO_ID )T1
    group by T1.EXTSYS_ID)However, i will prepare the create/insert statements and provide to the forum within few minutes.

    Regards
    RAT.

  • RELEVANCY SCORE 3.19

    DB:3.19:Duplicate Records With Query 7x


    I have a query using a foreign key that gives me a duplicates from the child table.  I should get only two records but it duplicates them so I get four.  Any ideas on what I am missing in the query? 
    Dim q1 = (From t In dc.Taxes _
    Where (t.TaxID = intTaxID) _
    Join c In dc.TaxCharges On t.TaxID Equals c.TaxID _
    Select etc.

    DB:3.19:Duplicate Records With Query 7x

    This is what worked.  I had a composite key I hadn't accounted for.
    Dim q1 = (From t In dc.Taxes, c In dc.TaxCharges _
    Where t.TaxID = intTaxID And c.TaxID = intTaxID And t.Status = c.Status _Select etc.

  • RELEVANCY SCORE 3.19

    DB:3.19:Remove Duplicates From Union Query aj


    The attached query (Query1) is designed to pull email addresses from a variety of sources in our DB and dump them into a single column. It works as written with one flaw - duplicate email addresses appear. This is because an email address can be associated
    with multiple CIFM_NBR.

    DB:3.19:Remove Duplicates From Union Query aj

    If you simply want a list of distinct email addresses then you merely have to remove the CIFM_NBR column from the query. A UNION operation automatically suppresses duplicate rows.

    If, on the other hand, you arbitrarily want to return only one CIFM_NBR value per distinct email address then put the UNION operation in a subquery e.g.

    SELECT CIFM_EMLHP_ADDR_502 AS EmailAddress,
    MIN(AllAddresses.CIFM_NBR) AS CIFM_NBR
    FROM
    (SELECT CIFM_EMLHP_ADDR_502, CIFM_NBR FROM 4_QRY_Final
    UNION
    SELECT CIFM_EMLHP_ADDR_505, CIFM_NBR FROM 4_QRY_Final
    WHERE CIFM_EMLHP_ADDR_505 IS NOT NULL
    and so on
    UNION
    SELECT EmailAddress, Null as CIFM_NBR FROM _20140128_ABCStaff
    UNION
    SELECT EmailAddress, Null as CIFM_NBR FROM _20140128_DEFStaff)
    AS AllAddresses
    GROUP BY CIFM_EMLHP_ADDR_502:CIFM_EMLHP_ADDR_50;

  • RELEVANCY SCORE 3.19

    DB:3.19:Alright. Stupid Question. My Program Is Loading Information From A Text File To A Listbox. Need To Remove Duplicates. x3


    The duplicates need to stay as they are in the text file. I just want the duplicates deleted from the listbox when viewed. How would I do that? Say there are two orders made by the same user. I only want the user to show up once in the listbox...

    DB:3.19:Alright. Stupid Question. My Program Is Loading Information From A Text File To A Listbox. Need To Remove Duplicates. x3

    Simply by uusing this code when you add the text into the listbox

    if ListBox1.FindStringExact(TheStringToAdd) = -1 then
    ListBox1.Items.Add(TheStringToAdd)
    End if

    Be aware typed in this message so watch typos.

    Success
    Cor

  • RELEVANCY SCORE 3.18

    DB:3.18:Set (Treeset,Hashset)Does Not Allow Duplicates .To Allow The Duplicates In aj


    set (treeset,hashset)does not allow duplicates .To allow the duplicates in TreeSet what we do?
    please give a sample example also.......

    DB:3.18:Set (Treeset,Hashset)Does Not Allow Duplicates .To Allow The Duplicates In aj

    Krishie,

    Please stop posting questions here until you have a) studied some basic Java, AND b) done some research on the topic on your own first AND c) learned how to ask a clear, detailed question.

  • RELEVANCY SCORE 3.18

    DB:3.18:Sql To Fetch Duplicates 33


    how to write a query
    which will select only duplicates from the single table

    thank u all

    DB:3.18:Sql To Fetch Duplicates 33

    120 columns is too many. However it's easy enough to copy and paste them from SQL*Plus etc, so the solution should not be affected.

    A subquery that returns all of the rows to be deleted in one shot will be more efficient than a correlated subquery.DELETE yourtable
    WHERE rowid IN
    ( SELECT LEAD(rowid)
    OVER ( PARTITION BY key1, key2, key3
    ORDER BY key1, key2, key3 )
    FROM yourtable );

  • RELEVANCY SCORE 3.18

    DB:3.18:Remove Duplicates 3c



    How can I remove duplicates values in my database?

    DB:3.18:Remove Duplicates 3c


    Intermodal2:

    LOAD distinct

    Key_Master,

    VOYAGE_DESC_2,

    VVL_D2,

    BOOK_ID,

    BL_Number_BDS,

    resident Intermodal;

    drop table Intermodal;

  • RELEVANCY SCORE 3.18

    DB:3.18:Duplicates 79


    I have a significant number of Duplicates in my library....how do i delete them???

  • RELEVANCY SCORE 3.18

    DB:3.18:Ht4620 Itunes Duplicates 99


    I just put a new hard drive in my computer and new operating system (switched from Vista to Windows 7). When I reloaded iTunes, I now have duplicates of every song in my library. How do I remove duplicates without having to remove them one by one?

    DB:3.18:Ht4620 Itunes Duplicates 99

    I just put a new hard drive in my computer and new operating system (switched from Vista to Windows 7). When I reloaded iTunes, I now have duplicates of every song in my library. How do I remove duplicates without having to remove them one by one?

  • RELEVANCY SCORE 3.18

    DB:3.18:How To Merge Items From Listlistint To Listint And Remove Duplicates In Linq Query mp


    Friends,
    I have ListListint and have 2 items each like
    [0] 1
    2
    [1] 3
    4
    [2] 5
    3

    I would like to get a result as only Listint and remove the duplicate data.
    so my result should be
    1
    2
    3
    4
    5
    How to do this in LINQ Query C#, i don't wanna do in loop. plz guide meThanks - Ravi

    DB:3.18:How To Merge Items From Listlistint To Listint And Remove Duplicates In Linq Query mp

    Do you need something like this?
    Listint list1 = new Listint();
    list1.Add(1);
    list1.Add(2);
    list1.Add(3);
    list1.Add(4);

    Listint list2 = new Listint();
    list2.Add(5);
    list2.Add(6);
    list2.Add(7);
    list2.Add(8);

    ListListint list = new ListListint();
    list.Add(list1);
    list.Add(list2);

    var a = list.SelectMany(x = x);

    Please Mark as Reply and Vote as Helpful if I helped.

    Also please visit my blog http://msguy.net/

  • RELEVANCY SCORE 3.18

    DB:3.18:How To Write A Method To Remove Duplicates Elements In List 1c


    help me please

    DB:3.18:How To Write A Method To Remove Duplicates Elements In List 1c

    You're wasting everyone's time now, Michelle. It's already been posted and answered in your other thread.

    %

  • RELEVANCY SCORE 3.17

    DB:3.17:Remove Duplicates In Oracle Table d3


    Hi,

    I want to remove duplicates from a Account table

    Contains 2 column Account_id and Account_type

    values in Account table are

    Account_id Account_type
    1 GPR
    1 GPR
    1 GPR

    I want only one entry and remove other entry with Account_Id = 1

    Thanks,
    Petri

  • RELEVANCY SCORE 3.17

    DB:3.17:Creating A Sub-Query To Combine Two Queries Into One 8c


    I have created two queries to find and combine quantities of duplicate part numbers from two different tables. Then I created a third query to find the unmatched parts and quantities from first Duplicates parts table query compared to the second Duplicates
    parts table query. I want to create a sub-query to combine the first two Duplicates' tables queries into one query. This query will find the duplicate parts and quantities from two different tables, and then compare one table's duplicate parts/combined quantities
    against the second table's duplicate parts/combined quantities. Is this possible, or do I have to keep using two separate queries to find the duplicates from each table first, before finding unmatched parts and quantities? Please see code below and any advice/help
    would be much appreciated.

    Find duplicates for CH2 ELIST EXTRACT
    SELECT [CH2 ELIST EXTRACT].[Part], SUM([CH2 ELIST EXTRACT].[Deliver]) AS [TOTAL QTY]
    FROM [CH2 ELIST EXTRACT]
    GROUP BY [Part]
    HAVING (((Count(*))=1))
    ORDER BY [CH2 ELIST EXTRACT].[Part];

    Find duplicates for ARLS DATA EXTRACT
    SELECT [ARLS DATA EXTRACT].PART, [ARLS DATA EXTRACT].DESCRIPTION, [ARLS DATA EXTRACT].VENDOR, Sum([ARLS DATA EXTRACT].QUANTITY) AS [TOTAL QTY], [ARLS DATA EXTRACT].SHORT
    FROM [ARLS DATA EXTRACT]
    GROUP BY [ARLS DATA EXTRACT].PART, [ARLS DATA EXTRACT].DESCRIPTION, [ARLS DATA EXTRACT].VENDOR, [ARLS DATA EXTRACT].SHORT
    HAVING (((Count(*))=1))
    ORDER BY [ARLS DATA EXTRACT].PART;

    Duplicates CH2 ELIST Without Matching Duplicates in ARLS DATA
    SELECT [Find duplicates for ARLS DATA EXTRACT].PART, [Find duplicates for ARLS DATA EXTRACT].DESCRIPTION, [Find duplicates for ARLS DATA EXTRACT].VENDOR, [Find duplicates for ARLS DATA EXTRACT].[TOTAL QTY], [Find duplicates for ARLS DATA EXTRACT].SHORT
    FROM [Find duplicates for ARLS DATA EXTRACT] LEFT JOIN [Find duplicates for CH2 ELIST EXTRACT] ON ([Find duplicates for ARLS DATA EXTRACT].PART=[Find duplicates for CH2 ELIST EXTRACT].Part) AND ([Find duplicates for ARLS DATA EXTRACT].[TOTAL QTY]=[Find duplicates
    for CH2 ELIST EXTRACT].[TOTAL QTY])
    WHERE ((([Find duplicates for CH2 ELIST EXTRACT].Part) Is Null));

    DB:3.17:Creating A Sub-Query To Combine Two Queries Into One 8c

    That's true, since I wanted to include all parts in the list (even those with Qty equal to one). The query groups all the same part numbers with quantities greater than or equal to one. This works and returns a list of duplicate parts with combined quantities
    - which is the intention of this single query.

  • RELEVANCY SCORE 3.17

    DB:3.17:"Find Duplicates" Command? as



    in pse 11, is there a "find duplicates" command?

    DB:3.17:"Find Duplicates" Command? as


    hi, thank you so much! i found it just where you explained!

    Pam Kruft

  • RELEVANCY SCORE 3.16

    DB:3.16:Itunes Duplicates zm


    I have multiple duplicates in my iTunes library. Is there a way to delete all the duplicates at once, and why did I get all the duplicates in the first place

    DB:3.16:Itunes Duplicates zm

    Yes, I need to know, too. I have uninstalled iTunes 2x and installed 3x (along w/quicktime, etc.) and still the duplicates are there. With my dupes, one copy says "the original could not be found" and there's an mark in the first column beside the dead copy. It's driving me nuts because I have huge number of tunes and don't have a week to delete every. single. dupe. If I could light up all the marks in the first column and select/delete them that would be ideal.

    Is it because I used Windoze Media Player? And do I have to delete the library from that program? Boy, what a PITA this is becoming...

  • RELEVANCY SCORE 3.16

    DB:3.16:Copy Over A Column And Remove Duplicates With Removing Empty Rows df


    Is is possible please to copy over one column of data. The data has rows in it that are duplicates of each other. The macro would both remove the duplicates (this then leaves empty rows). Then remove the empty rows? Can someone provide a solution as nothing seems to be working for me, can someone help please? Thanks, Jez

    DB:3.16:Copy Over A Column And Remove Duplicates With Removing Empty Rows df

    Hi, I put a simple ADODB example together, which assumes that your data is in column A on Sheet1 with a heading of MyList, and that you want the data starting in B2. Change the items in bold to your requirementsPublic Sub CopyColumn()On Error Resume Next
    Const adOpenStatic = 3Const adLockOptimistic = 3Const adCmdText = H1
    Set objConnection = CreateObject(ADODB.Connection)Set objRecordset = CreateObject(ADODB.Recordset)
    objConnection.Open Provider=Microsoft.Jet.OLEDB.4.0; _    Data Source=C:\Data\Book1.xls; _        Extended Properties=Excel 8.0;HDR=Yes;;
    objRecordset.Open Select Distinct MyList  FROM [Sheet1$] , _    objConnection, adOpenStatic, adLockOptimistic, adCmdText
    Worksheets(Sheet1).Range(B2:B2).CopyFromRecordset objRecordset
    End Sub

  • RELEVANCY SCORE 3.16

    DB:3.16:Eliminating Duplicates And Returning Both The Uniques And Eliminated Duplicates 7f


    Hi!
    In T-SQL in SQL Server 2008 or 2008 R2, is it possible to search from a view with some criteria (the WHERE clause) and then from this resulting set (1) delete duplicates and then (2) return both the unique rows and the (3) duplicates in their (4)
    own groups? Mainly I'm interested in just returning the unique rows and deleting the duplicates with one and a same query, but it would make a nice reporting feature to have the deleted duplicates returned as well. I'm somewhat noobish regarding SQL queries,
    so I'm not sure if I would like to have is doable. This is more like educational effort, since I have a feeling knowing how to do something like this will be ahead sometime.
    I have read, for instance, Suresh Magantis' very enlightening article
    Eliminating Duplicate Rows using The PARTITION BY clause, but using this technique I would have to first remove the duplicates and then do the search again to give the unique
    keys. That is, I don't know how I would select the unique ones and delete the duplicate ones. Is it doable with views? Is it doable to have both the unique keys, duplicates and also delete the duplicates?
    Would a with clause help here? The deletion in Sureh's post could be handled by a with clause like so:

    WITH numbered_rows
    AS (SELECT data, row_number() OVER (PARTITION BY data ORDER BY data) AS rank_number
    FROM DuplicateTable)
    DELETE FROM numbered_rows
    WHERE rank_number 1

    DB:3.16:Eliminating Duplicates And Returning Both The Uniques And Eliminated Duplicates 7f

    Sorry for the late delay (weekend chores at home and so on), but you are right. Kind of shows I'm a rather rookie with relational technology.
    Thank you for going through the trouble to guide me.Sudet ulvovat -- karavaani kulkee

  • RELEVANCY SCORE 3.15

    DB:3.15:Remove Duplicates Where First Name, Lastname,Mobilenumber Are Equal 11


    My database is composed of contact data from several sources. This means I have a lot of duplicate contacts. What do I need to put into a query so that I will remove entries with the same first name, last name and mobile number are the exact same? I cannot
    do just firstname and lastname because there are contacts with the same first,last name who are different people and work for different companies, sometime even the same company. I've considered using the Delete Duplicates procedure in Access based on the
    Mobile Number, but too many entries have null mobile numbers with the same first and last names. What do I need to put in the query grid?

    Thank you.

    DB:3.15:Remove Duplicates Where First Name, Lastname,Mobilenumber Are Equal 11

    Also, if possible, could you instruct me as to how to enter this into the query grid? Since, I have no training in writing code, I would understand things better.

    Thank you.

  • RELEVANCY SCORE 3.14

    DB:3.14:In A Web Cbo, Is There A Way To Prevent Duplicates From Being Displayed dj


    I'm trying to create a cbo that dispays, say the States of the US. The cbo is based on a very simple query.

    The WEB query properties do not allow selection of unique records or values as a normal query does. The RowSource property of the cbo cannot use a "Select Distinct" statement to prevent duplicates.
    Does anyone know of another way to prevent duplicates from being displayed in a WEB cbo or query?

  • RELEVANCY SCORE 3.13

    DB:3.13:Removing Duplicates a8


    Hello eveyone,

    I am trying to remove duplicated rows from a table.

    The rowcount is around 200k and it is taking very long time( did not return in 3 hrs) to complete this.
    Query

    Delete from mytable1 where rowid not in
    ( select max(rowid) from mytable1 group by contract_number)

    Can anyone please tell me if there is any better way to achieve this.

    Thanks in advance,
    Avinash

    DB:3.13:Removing Duplicates a8

    Someone here edited his post, so thread was on top of thread list, but I didn't see the last post date, sorry.

    Message was edited by:
    N. Gasparotto

  • RELEVANCY SCORE 3.13

    DB:3.13:Remove Duplicates In Resultsetmetadata p7


    when i do this query:

    select * from yard_engine_rule a, yard_engine_rule_matrix b where a.RULE_ID = b.RULE_IDit shows this result

    RULE_ID
    RULE_M
    LOCATION_TYPE_C
    DESCRIPTION_X
    RULE_ID
    MODULE_M
    PLANNING_TYPE_C
    CNTR_GROUP_C
    TERMINAL_C
    CONSTRAINT_TYPE_C
    PREPROCESS_I
    CONFIG_VALUE_X
    PRIORITY_N
    PLANNING_LEVEL_Nnotice that there are two 'RULE_ID', but i only want to have one of them, how do I go about it?

    DB:3.13:Remove Duplicates In Resultsetmetadata p7

    Then use getTableName as well as getColumnName. If it is about being able to use getString, or some other get method using the columnname, then sorry, use the index.

  • RELEVANCY SCORE 3.12

    DB:3.12:Duplicates xk


    What is the best way to see duplicates directly in an Access table (no VBA). If I am not mistaken we can create a query but I don't remember how. I would like to see them before I delete them. Thanks.

    DB:3.12:Duplicates xk

    If by that you mean using the query design interface rather than SQL view, you can first create a query which groups by the columns which determine what is duplication, then count any non-Null column, e.g. the table's primary key, and include a criterion
    of 1. So in my example the relevant rows of the design grid would look like this:

    Field: FirstName LastName ContactID
    Total: Group By Group By Count
    Criteria: 1

    Save this query and then create another query which joins the same table to the above query on the columns which determine what is duplication, FirstName and LastName in the above example. Return all the columns from the table in the query. The query will
    return all rows where there is duplication in both the FirstName and LastName columns.

  • RELEVANCY SCORE 3.12

    DB:3.12:Remove Duplicates In List fz


    Hi,
    I got a problem with removing duplicates in my list. I have written following code

    for (int i = 0; i policies.size(); i++)
    {
    String policies1 = policies.get(i).toString();
    for (int j = i + 1; j policies.size(); j++)
    {
    String policies2 = policies.get(j).toString();
    if (policies1.equalsIgnoreCase(policies2))
    {
    policies.remove(j);
    }
    }
    }

    I have 4 strings with same names but i am able to remove only 2 duplicates from the list where it should remove 3

    DB:3.12:Remove Duplicates In List fz

    ... classic [deletion] gotcha ...java.util.Iterator's [optional] remove method solves this, shame it's not allways implemented.

  • RELEVANCY SCORE 3.12

    DB:3.12:Unique Value Formula And Excels Remove Duplicate Feature 73


    I got this formula: =SUMPRODUCT(1/COUNTIF(A$3:A$3119,A$3:A$3119)) from
    TasosKwhich seem to work fine. But when I use the Remove Duplicates feature of Excel, I get different values. The formula gives me one value and the remove duplicates feature result in a different value.
    Any ideas.

    DB:3.12:Unique Value Formula And Excels Remove Duplicate Feature 73

    I got a different count when I use the formula. When I copied the same data into another sheet and used Excel Remove Duplicates feature, that gave me a different count than I got when I used the formula.

  • RELEVANCY SCORE 3.12

    DB:3.12:Duplicates Of Calendar Events xz


    Trying to iSyn with my Palm has left my calendar littered with duplicates. I give up on syncing. Is there a way to remove the duplicates in my computer's iCal calendar without doing it one item at at time?

    DB:3.12:Duplicates Of Calendar Events xz

    John-
    Does your script still work?? I ran it all morning and still have tons of duplicates.

  • RELEVANCY SCORE 3.12

    DB:3.12:Duplicates kj


    Hi
    Is there a feature in iPhoto that lets you detect duplicates in your library?

    DB:3.12:Duplicates kj

    iPHoto will detect if you're trying to import a duplicate file and warn you with an option to either allow or disallow. At least most of the time. Some users have had trouble with that for some reason when importing directly from a camera but not when importing from a folder on the desktop. But once they are already in the library then we need to use the 3rd party solutions.

  • RELEVANCY SCORE 3.12

    DB:3.12:How Do I Delete Duplicates Using Query x1


    I can use Find Duplicates query to find duplicates in my table, but have difficulty building a query to delete those duplicates from my table. Can anyone help?

    DB:3.12:How Do I Delete Duplicates Using Query x1

    Hi Paul,

    I have been able to resolve it. Thanks.
    Jerry

  • RELEVANCY SCORE 3.12

    DB:3.12:Remove Duplicates z9


    Hi,
    I am want to create a primamry key on column a in table FARA, I am receiving an error that I have duplicates in column a.
    I tried copying the table using : select distinct into table FARA-u from table FARA. thought this should remove duplicates but I am still getting same error when i try to set primamry key on column a. how can i remove those duplicates ( I wil need to remove
    the whole row that conatins duplicates on column a)
    Thanks!

    DB:3.12:Remove Duplicates z9

    I think it worked out!
    thank u chirag and Naom

  • RELEVANCY SCORE 3.11

    DB:3.11:Remove Duplicates 77


    Hi...I have around 100+ tables for which I would need to remove duplicates based on the primary key columns. These 100+ tables doesnt have primary key constraints, but after cleaning the duplicates I would need to load these 100+ tables data into the actual tables.The problem I face is, the primary key columns count change by table. For example, table T1 has 1st 3 columns as Primary keys, table T2 has 1st 4 columns as Primary keys and so on.I just wanted to check if there is a generic way/query to remove the duplicates for these 100+ tables rather than 100+ queries..Sorry, if my question is not clear or too naive...RegardsN

    DB:3.11:Remove Duplicates 77

    Thank you Frank. Next time when I post a question, I will remember these things and post accordingly...And thanks a lot for the answer

  • RELEVANCY SCORE 3.11

    DB:3.11:App: Remove Your Duplicates 79


    thoseannoyingdupes.com

    Add your lists by playlist URL (limited to 1000 tracks) or tracks (unlimited).

    This app will list your dupes by name, so you can easily find them in your playlist.

    It will also make you a new playlist without duplicates, if you prefer to make a new one (will reset the tracks' added date)

    Edit: New version with better and more user friendly interface:

    DB:3.11:App: Remove Your Duplicates 79

    thoseannoyingdupes.com

    Add your lists by playlist URL (limited to 1000 tracks) or tracks (unlimited).

    This app will list your dupes by name, so you can easily find them in your playlist.

    It will also make you a new playlist without duplicates, if you prefer to make a new one (will reset the tracks' added date)

    Edit: New version with better and more user friendly interface:

  • RELEVANCY SCORE 3.11

    DB:3.11:Possible To Not Use Distinct Keyword In Select Query? mx


    I have a high repetition query that polls the database and only ever uses
    the first row returned from the query. Using the distinct keyword adds
    overhead and increases the use of tempdb in SQL Server in order to remove
    any duplicates. Is there a way to instruct kodo not to use distinct on an
    ad-hoc basis?

    We are using 3.2.3 on SQL Server 2000

    Regards
    Nathan

  • RELEVANCY SCORE 3.11

    DB:3.11:Remove Duplicates From One Column And Place In Another.....Is There Any Available Formula sj


    Looking for a formula to remove duplicates from one column and place the duplicates in another column.
    If possible...I'd like only 2 columns. I'd like to have the duplicate values removed from the original col. 1. See final output below. Not sure if a macro is required for this. Please Assist.....Thank You!

  • RELEVANCY SCORE 3.10

    DB:3.10:Create Query With Unique Records mm


    I have a query that is showing records from a table that has many duplicate records. How can I refine the query to only show unique records? There are records that are close to duplicates, but in order to be duplicates they have to have the same data in
    more than 1 field (9 fields).

    THANKS

    DB:3.10:Create Query With Unique Records mm

    You can return one instance of DOB and Address per group by using the FIRST or LAST operators. Despite their names these operators don't really do what you might think, but they do ensure that both values returned are from the same row, but the row is
    to all intents and purposes selected arbitrarily. Adding this to Karl's query would give you:

    SELECT [first name], [last name], [No], [amt], [date], [PMT Date], [Trans No], [claim date], [code],
    FIRST([YourTable].[DOB]) AS DOB, FIRST([YourTable].[Address]) AS Address
    FROM [YourTable]
    GROUP BY [first name], [last name], [No], [amt], [date], [PMT Date], [Trans No], [claim date], [code];

    This does of course involve information loss, so you should really be looking towards decomposing the imported table into a set of correctly normalized related tables. A file, DecomposerDemo.zip, in my public databases folder at:

    http://cid-44cc60d7fea42912.skydrive.live.com/redir.aspx?resid=44CC60D7FEA42912!169

    illustrates how this is done by executing a series of 'append' queries, using a simple contacts list as an example where contacts can have multiple employers.

  • RELEVANCY SCORE 3.10

    DB:3.10:Removing Duplicates Using Sort Transform cj


    There are other threads on this subject but I really haven't seen a definitive answer.If my data is sorted in a particular order (in a previous Sort Transform) and I use another Sort Transform to remove duplicates, will the last row for each duplicate (or multiple) be kept?

    DB:3.10:Removing Duplicates Using Sort Transform cj

    I forgot to point you to a post I'd written that has a bunch of options laid out - including (I think) everything we'd talked about here!  Eliminating Duplicate Primary Keys in SSIS.

  • RELEVANCY SCORE 3.10

    DB:3.10:Query Duplicates 3a



    Hi Experts,

    We have a situation here with queries having duplicate names.

    How can I get rid of the duplicates?

    Regards,

    Sam

    DB:3.10:Query Duplicates 3a


    System will allow Queries with same Technical name but different description and vice versa.

    If you think the same query is repeating,you need to manually delete the queries.

    assign pts if it is useful,thanks

  • RELEVANCY SCORE 3.10

    DB:3.10:Why Do I Now Have Tons Of Duplicates In Version 11? ps


    I have almost all my music in the cloud. With version 10 I really don't recall seeing many duplicates. Now almost all the music that was orginaly from my CD's have duplicates. Seems like the only stuff not duplicated are purchases made thru the ITunes store.I know version 10 had a remove duplicates path - I can't find it on 11.I am beginning to think I made a mistake spending 25 dollars per year and trusting Apple with my music.How do I eliminate duplicates in version 11?

    DB:3.10:Why Do I Now Have Tons Of Duplicates In Version 11? ps

    I have almost all my music in the cloud. With version 10 I really don't recall seeing many duplicates. Now almost all the music that was orginaly from my CD's have duplicates. Seems like the only stuff not duplicated are purchases made thru the ITunes store.I know version 10 had a remove duplicates path - I can't find it on 11.I am beginning to think I made a mistake spending 25 dollars per year and trusting Apple with my music.How do I eliminate duplicates in version 11?

  • RELEVANCY SCORE 3.09

    DB:3.09:Program Manager 39


    I have about 35,000 lines of data in Excel 2012 and I am trying to remove duplicate. I have several columns with headers such as kit ID, dates, names, addresses, city, county, state, test results. I have highlighted the duplicate test kit ID numbers with
    the conditional formatting. When I go to the DATA tab on the ribbon and hit Remove Duplicates it only removes a few of the duplicates, leaving several thousand duplicates still in the s/s.
    I am highlighting the Kit ID number column and checking only the Kit ID number column when prompted.
    Also, many of the Kit ID numbers have green triangles with them. Right now, I have to manually delete the duplicate rows.
    How can I get Remove duplicates to remove all of the duplicates?

    DB:3.09:Program Manager 39

    Hello Steve,
    Please note that this threadis relatedto developing Excel solutions (not use).

    Anyway, you can try to install and use third-party additions (add-ins) for Excel. For example, you can try installing the

    Duplicate Remover tool from theAblebits team. A free 15-daystrial period is provided for testing your data files.

  • RELEVANCY SCORE 3.09

    DB:3.09:Retrieve Data Based On Duplicates Subquery s3


    Hi,

    I need to retrieve data from tables, but only for records where a particular field is duplicated. The problem is that I can identify the duplicates using the usual '... HAVING COUNT(*) 1' query, but how do I retrieve data using another query based on the output from the duplicates query, as the duplicates query returns the duplicated item as well as the count(*), so I cannot place the duplicates query in an EXISTS condition?

    The following is my current outer SQL statement:

    SELECT
    cust.full_billing_reference,
    brand.brand_description,
    cust.supply_name,
    addr.mailing_name,
    addr.mailing_postcode,
    addr.mailing_tel_no
    FROM
    cust,
    brand,
    addr,
    fnew
    WHERE fnew.brand_sk =brand.brand_sk
    AND fnew.customer_sk =cust.customer_sk
    AND addr.customer_sk =fnew.customer_sk
    AND (
    fnew.segmentation_code = 'SME'
    AND cust.i_acct_ca BETWEEN 10000 AND 20000
    )

    And the following is my current duplicates query:

    SELECT
    addr.mailing_postcode,
    count(*)
    FROM
    dw_owner.rsb_dim_customer_address addr,
    dw_owner.rsb_dim_customer cust,
    dw_owner.rsb_fact_new fnew
    WHERE fnew.customer_sk=cust.customer_sk
    AND addr.customer_sk=fnew.customer_sk
    AND (
    cust.i_acct_ca BETWEEN 10000 AND 20000
    AND fnew.segmentation_code = 'SME'
    )
    GROUP BY addr.mailing_postcode
    HAVING COUNT (*) 1

    DB:3.09:Retrieve Data Based On Duplicates Subquery s3

    Use analytic functions:

    SQL select ename, col1 from emp1
    2 order by 1,2;

    ENAME C
    ---------- -
    ADAMS 1
    ADAMS 2
    ALLEN 1
    BLAKE 1
    CLARK 1
    FORD 1
    FORD 2
    JAMES 1
    JONES 1
    JONES 2
    KING 1
    MARTIN 1
    MILLER 1
    SCOTT 1
    SCOTT 2
    SMITH 1
    SMITH 2
    TURNER 1
    WARD 1

    19 rows selected.

    SQL select ename, col1 from
    2 (select ename, col1, count(*) over(partition by ename order by null) cnt
    3 from emp1)
    4 where cnt 1;

    ENAME C
    ---------- -
    ADAMS 2
    ADAMS 1
    FORD 1
    FORD 2
    JONES 1
    JONES 2
    SCOTT 1
    SCOTT 2
    SMITH 2
    SMITH 1

    10 rows selected.Rgds.

  • RELEVANCY SCORE 3.09

    DB:3.09:How Do I Remove Duplicate Assets In A Slideshow In Muse Cc? 1c



    I have a tablet, desktop and phone version of a Muse site I have built. I seem to have duplicates of the photos in the assets panel. Can someone tell me if there is a quick way to remove the duplicates? I oterwise have to go in and show the thumbnails and then manually remove each duplicate. This seems a bit long winded. Help?

    DB:3.09:How Do I Remove Duplicate Assets In A Slideshow In Muse Cc? 1c


    The assets panel inside Muse duplicates exactly what is on your website pages. There should be no duplicates, if there are that means you have those images placed somewhere else on your site. I wouldn't recommend deleting anything in the assets folder as it will delete it on your website.

  • RELEVANCY SCORE 3.08

    DB:3.08:Find And Remove Duplicate Photos m1


    I recently copied or imported a large number of photos from external drives to iphoto, but the process seems to have peppered many duplicates of photos throughout my collection. Usually I iphoto asks if duplicates should be deleted, but it didn't in these instances. Is there a way for iphoto to search and identify duplicates and then delete those extras?

  • RELEVANCY SCORE 3.06

    DB:3.06:Deleting Duplicates In Iphoto - Effects On Time Machine Backup xm


    I am new to Time Machine Backup. I have a query, (perhaps a silly one?)
    Out of 4500 photos in my iPhoto, I have trashed 300 duplicates.
    On my next backup in Time Machine on an Ext HD, will the deleted photos be also gone?
    What about the duplicates that I originally stored in my Hard Drive under My Pictures? Are they also stand deleted?

    DB:3.06:Deleting Duplicates In Iphoto - Effects On Time Machine Backup xm

    Retired Engineer wrote:
    ...it will eventually be deleted from the time machine backup drive when it gets full and more storage space is needed.
    Yes thats clear now. So long the TM Drive has space I will be able to restore the deleted ones. Thanks!

  • RELEVANCY SCORE 3.06

    DB:3.06:What Does The Duplicates:624 Mean In Search Query Box? sk


    When I do a search and the result contains duplicates, when I click the View duplicates, the search box's text turned into something like duplicates:624. What does this mean?
    For example, when I search poles, The Search Text box has text poles.
    The result is

    Crews search for, 3 hikers in (California) CNN

    DB:3.06:What Does The Duplicates:624 Mean In Search Query Box? sk

    Hi Ehtand,
    View Duplicates means that more than one same version of the document exists in your sharepoint environment. It only shows the more relevante Document on first place but you can find that document in other locations. 624 is the id of the document in your
    search index.
    Regards Stefan.http://www.n8d.at/blog
    MCTS - SharePoint / WSS Configuration and Development

  • RELEVANCY SCORE 3.06

    DB:3.06:Can I Automatically Delete Duplicates In One Move 3p


    i had made lots of folders and backups all over my hard drives and i just imported the full thing into itunes onto a 500 gb hard drive. Now i have 75 Gb of duplicates, ( in view show duplicates )

    can i remove duplicates in one click or do i have to check them one by one and delete them individually

    DB:3.06:Can I Automatically Delete Duplicates In One Move 3p

    I haven't run the duplicate eliminator script myself - only the dead track eliminator.

    The way these scripts usually work is you select a playlist and the operation is applied to that playlist. Playlist 1. being the entire library.

    If you want more specific help with the scripts, Robert Jacobson is often about on this forum so a new topic with Tridon scripts or Robert Jacobson in the title would attract his attention alternatively if you look at the Teridon web bage you will see a link to a discussion group for the scripts.

  • RELEVANCY SCORE 3.05

    DB:3.05:Triggers Constraints fz


    hi

    If I have some duplicates alredy existing in a table, and now I think of avoidng duplicates entry in future by writing some triggers or so.My question is if I write a trigger for a table having duplicates and I want to retain the already existing duplicates(so that I can check and remove them in future) but apply the trigger to the table from now. Is it possible

    DB:3.05:Triggers Constraints fz

    Oh, this is more better for OP.
    Simple and safe on multi-user access.

    SQL create table tab1 (i int, d varchar(10));

    Table created.

    SQL insert into tab1 values (1,'data1');

    1 row created.

    SQL insert into tab1 values (1,'data11');

    1 row created.

    SQL insert into tab1 values (2,'data2');

    1 row created.

    SQL create index i_tab1 on tab1(i);

    Index created.

    SQL alter table tab1 add constraint i_tab1 unique (i) novalidate;

    Table altered.

    SQL insert into tab1 values (1,'data12');
    insert into tab1 values (1,'data12')
    *
    ERROR at line 1:
    ORA-00001: unique constraint (USHI.I_TAB1) violated

    Thank you for your nice advice.

  • RELEVANCY SCORE 3.05

    DB:3.05:Re: Arraylist - Removing Duplicates ad


    Just use a Set contstructor to remove the duplicates. Use another
    ArrayList constructor to get the unique values back in an ArrayList again.

    kind regards,

    Jos

    DB:3.05:Re: Arraylist - Removing Duplicates ad

    I did not even read what they replied for the OP.I could have known. That's one of the reasons you come up with bad
    advice and useless replies time after time.

    Jos

  • RELEVANCY SCORE 3.05

    DB:3.05:How To Eliminate Duplicates In Hibernate Criteria Query 1f


    Hi all,
    Anyone who know how to eliminate duplicates in Hibernate Criteria Query ?

    Thanks,
    Lanz

  • RELEVANCY SCORE 3.05

    DB:3.05:Array Duplicate Remove... 7j


    This one is a little wierd.... the code that I have will remove the duplicates... but I what to remove the orginal one.(Once it finds the duplicates remove all occurrences)so that the numbers in the list are unique...
    Joined.AddRange(Array1);
    Joined.AddRange(Array2);
    Array3 = (from a in Joined select a ).Distinct().ToArrayString();
    Anythoughts.....

    Thanks

    DB:3.05:Array Duplicate Remove... 7j

    Got It to work ... I had to pre- join the arrays to one arrray.. to add to the list so that it could be accounted for in the list .. so that it could be removed...

    Thanks for the awsome work.. and not giving up on me....LOL
    Later

  • RELEVANCY SCORE 3.05

    DB:3.05:Ht1338 I Have About 88,000 Songs In My Music Library, Some Are Duplicates. Does Anyone Know Of Any Apple Product Or 3rd Party Software That Will Identify And Remove Duplicates. zc


    I have about 88,000 songs in my music library, some are duplicates. Does anyone know of any Apple Product or 3rd party software that will identify and remove duplicates.

    DB:3.05:Ht1338 I Have About 88,000 Songs In My Music Library, Some Are Duplicates. Does Anyone Know Of Any Apple Product Or 3rd Party Software That Will Identify And Remove Duplicates. zc

    Note, I don't know how you ended up posting to the 10.3 forum, but Mac OS X 10.3 will not run on MacBook Pros. To find your Mac OS X version, go to Apple menu - About This Mac, and in the future please post the forum more closely resembling your issue. I've asked the moderator to move this thread to the correct forum.

  • RELEVANCY SCORE 3.04

    DB:3.04:How To Remove Duplicate Records In A Sql Query az


    Hi,

    Please help advise on the following.

    Is there a function that allows me to remove the duplicates in the query below?

    SQL :
    select ItemID, CheckoutTime, InQty, OutQty from table

    ItemID CheckoutTime InQty OutQty
    ---------- -------------------- ----- --------
    10004/1/2007 11:10:01AM4030
    12004/2/2007 11:10:01AM3020
    12004/2/2007 10:10:01PM2010
    1200 4/3/2007 08:10:01PM10 8

    In the above example, if there are 3 records of the ItemID '1200' , then i'd like to retain/display only the record with a latest 'CheckoutTime'.

    Is that possible?

    Please advise. Thanks for your help!

    DB:3.04:How To Remove Duplicate Records In A Sql Query az

    SQL with checkout as
    2 (select 1000 itemid, to_date('4/1/2007 11:10:01','mm/dd/yyyy hh24:mi:ss') checkouttime,
    3 40 inqty, 50 outqty from dual
    4 union all
    5 select 1200 itemid, to_date('4/2/2007 11:10:01','mm/dd/yyyy hh24:mi:ss') checkouttime,
    6 30 inqty, 20 outqty from dual
    7 union all
    8 select 1200 itemid, to_date('4/2/2007 22:10:01','mm/dd/yyyy hh24:mi:ss') checkouttime,
    9 20 inqty, 10 outqty from dual
    10 union all
    11 select 1200 itemid, to_date('4/3/2007 20:10:01','mm/dd/yyyy hh24:mi:ss') checkouttime,
    12 10 inqty, 8 outqty from dual)
    13 select * from checkout;

    ITEMID CHECKOUTT INQTY OUTQTY
    ---------- --------- ---------- ----------
    1000 01-APR-07 40 50
    1200 02-APR-07 30 20
    1200 02-APR-07 20 10
    1200 03-APR-07 10 8

    SQL with checkout as
    2 (select 1000 itemid, to_date('4/1/2007 11:10:01','mm/dd/yyyy hh24:mi:ss') checkouttime,
    3 40 inqty, 50 outqty from dual
    4 union all
    5 select 1200 itemid, to_date('4/2/2007 11:10:01','mm/dd/yyyy hh24:mi:ss') checkouttime,
    6 30 inqty, 20 outqty from dual
    7 union all
    8 select 1200 itemid, to_date('4/2/2007 22:10:01','mm/dd/yyyy hh24:mi:ss') checkouttime,
    9 20 inqty, 10 outqty from dual
    10 union all
    11 select 1200 itemid, to_date('4/3/2007 20:10:01','mm/dd/yyyy hh24:mi:ss') checkouttime,
    12 10 inqty, 8 outqty from dual)
    13 select itemid,
    14 checkouttime,
    15 inqty,
    16 outqty
    17 from (select itemid,
    18 checkouttime,
    19 inqty,
    20 outqty,
    21 row_number() over (partition by itemid order by checkouttime desc) rn
    22 from checkout) chk
    23 where chk.rn = 1;

    ITEMID CHECKOUTT INQTY OUTQTY
    ---------- --------- ---------- ----------
    1000 01-APR-07 40 50
    1200 03-APR-07 10 8

    SQL

  • RELEVANCY SCORE 3.04

    DB:3.04:Remove Duplicates. 1d


    I have a list of names in excel and I need to remove all names that appear more than once. Remove duplicate command would keep one copy of each name. I’m looking for a way to remove all copies of duplicate items.
    thank you

    DB:3.04:Remove Duplicates. 1d

    For the example assume names are in column A and start at row 2 if column header is present.
    Insert a helper column next to the column with the names.
    In Cell B2 insert the following formula. Note the absolute addressing of the range with the $ signs. Edit the last cell to suit your last cell
    =COUNTIF($A$2:$A$200,A2)
    Copy the formula to the bottom of the data.
    Select the column and Copy - Paste Special - Values
    Turn on AutoFilter
    Set the filter containing the counts. When setting the filters, if not too many numbers then just select the numbers greater than 1. Otherwise select the Number Filters - Greater than and set to greater than 1.
    Select all of the rows (excluding column header)and then at the far right of the Home ribbon select Find Select - Goto Special and select Visible cellsonly.
    Right click over a selected area and Delete Row.
    Turn off AutoFilter.
    Delete the helper column.

  • RELEVANCY SCORE 3.04

    DB:3.04:Duplicates 1j


    Hi,
    How to remove the duplicate records in a table?

    DB:3.04:Duplicates 1j

    http://dimantdatabasesolutions.blogspot.co.il/2007/02/dealing-with-duplicates.htmlBest Regards,Uri Dimant SQL Server MVP,
    http://sqlblog.com/blogs/uri_dimant/

    MS SQL optimization: MS SQL Development and Optimization
    MS SQL Consulting:
    Large scale of database and data cleansing
    Remote DBA Services:
    Improves MS SQL Database Performance
    SQL Server Integration Services:
    Business Intelligence

  • RELEVANCY SCORE 3.04

    DB:3.04:Removing Duplicate Records jp


    Please guys I hada task and believe a single sql can do it although I have achieved it using plsql.

    I have a set of records that contain duplicates. I was able to find all duplicates with the query

    SELECT *
    FROM loan l JOIN loan n
    ON l.policy_number = n.policy_number
    AND l.effective_date = n.effective_date
    AND l.amount = n.amount
    where l.LOAN_ID n.LOAN_ID order by l.POLICY_NUMBER

    according to the above, record is duplicate if it has the same policy_number, amount and effective date but not the same loan_id.
    Now the task is to remove the duplication which is the record with the lower loan_id (the loan_id is a number column) in a group of duplicates.

    Regards

    DB:3.04:Removing Duplicate Records jp

    hoek wrote:
    Nice one, Isotope!Thank you, hoek !

  • RELEVANCY SCORE 3.04

    DB:3.04:Check For Duplicates Query In Web Database? z9


    Hello,

    I'm working on converting an Access 2010 database to a web database and I'm having trouble converting some parts. Right now I am trying to figure out how to make a query which checks for duplicates. It was very easy to make a Access client query
    to check for duplicates but I can't seem to find a way to make a web query that checks for duplicates.

    Any help would be very appreciated!

    DB:3.04:Check For Duplicates Query In Web Database? z9

    Seems you've cross post the quesion on our Answer forum,are you satisfiled the reply from our MVPAlbert D. Kallal?
    http://answers.microsoft.com/en-us/office/forum/office_2010-access/check-for-duplicates-query-in-web-database/8be865c5-33fc-4e5e-8083-cee82bc76568
    Tony Chen
    TechNet Community Support

  • RELEVANCY SCORE 3.03

    DB:3.03:Is There A Way To Remove Duplicates From One Worksheet And Place The Duplicates In Another Worksheet sx


    Is there a way to automatically remove duplicates from one worksheet and place the duplicates in another worksheet? I would like to keep track of the duplicates I am removing in a seperate worksheet instead of having them removed completely and not know
    what duplicates I have removed.

    Thanks!
    Erik

    DB:3.03:Is There A Way To Remove Duplicates From One Worksheet And Place The Duplicates In Another Worksheet sx

    The way I normally do it involves a bit of eye balling the dupes- intentionally
    Firstly to identify the dupes- use either 1 field or concatenate two 0r more (=A1B1 etc)
    Sort by this column e.g "H"- then on another column say "I" us a formula like =IF(H15=H14,"Dupe",IF(H15=H16,"Dupe",""))---- row 14 being start of my data.

    Filter on dupes then identify which of the duplicate rows contains the best info- you may have a dupe of email address- but only one of them has the name correctly
    Then simply filter on the ones to come out- paste to new sheet- then delete them from the original
    HTH

  • RELEVANCY SCORE 3.03

    DB:3.03:Open With Menu Duplicates. Osx 10.8.1 zm


    It shows duplicates of VLC in the open with menu when I go to open a movie file. I am running osx mountain lion 10.8.1. How do I remove duplicates or fix the open with menu?

    DB:3.03:Open With Menu Duplicates. Osx 10.8.1 zm

    Worked for me too - I edited command in TextEdit to get rid of line break and then pasted into Terminal.After over 10 years as a Mac user first time I've used Terminal! I'm so pleased you posted the command correctly.Thank you - the duplicate icons were most annoying.Message was edited by: PeterinWales - spelling

  • RELEVANCY SCORE 3.03

    DB:3.03:Email Duplicate Removal? k1


    any recommendations for a plugin to remove duplicates in Mac Mail?TIA

    DB:3.03:Email Duplicate Removal? k1

    any recommendations for a plugin to remove duplicates in Mac Mail?TIA

  • RELEVANCY SCORE 3.03

    DB:3.03:Remove Duplicates From The Target Glide 3p



    Hi all,would like remove duplicates from the target on below code. i have some user in a array and extracting the user from groupmembers table and need to remove all duplicate values.for (var j=0; j users.length; j++) {gs.log('2.5 Checking for '+users[j]);var tgt= new GlideRecord('sys_user_grmember');tgt.addQuery('user',users[j]);// runningtgt.query(); //Remove any duplicates from group string from the tgt.pleas suggest.

    DB:3.03:Remove Duplicates From The Target Glide 3p


    Hi Patricia,

    I would run this script in an ondemand schedule job. If you have the access (security_admin role) you can even use 'scripts - background' for the same. Running above script once is sufficient to remove duplicate entries of users in all groups. i would suggest you to test this script in sandbox first.

    Line 15: replace '==' with '='. My bad.