Questions tagged [duplicate-data]

354 questions
2
votes
1 answer

User defined function for tagging duplicates

I'm trying to create a function that will identify duplicate samples (rows) based off of an ID number and create a new column which will write the test order of the duplicated samples (if any). The duplicate samples will have the same ID, but will…
GK89
  • 646
  • 5
  • 29
2
votes
2 answers

Using Javascript to pull cell data from one table to another

I don't know if this is possible, and I've been digging around for code for hours with no luck, so I'm going to give this a shot. Let's say I have a table on a page. It contains the following: …
2
votes
1 answer

Finding Duplicate Entry from multiple table in mysql

I have three tables having following structure Table Name : users id name age 1 Alok 26 2 Ashok 28 3 Amit 25 Table Name : Departments id name d_name 1 Alok Ops 2 …
2
votes
3 answers

Highlight rows where the same values in columns A:B but different values in column C

I have 4000+ rows of data need to be working on. Where column A represents the SKU, column B represents the unit and column C represents the Unit Price. The same SKU, Unit and Unit Price may duplicate at their own columns as shown as the picture…
2
votes
2 answers

SQL query producing duplicate rows and I can't see why

My query always produces duplicate results. How best do I go about troubleshooting this query with a database > 1 million rows. Select segstart ,segment ,callid ,Interval ,dialed_num ,FiscalMonthYear ,SegStart_Date …
CodingIsAwesome
  • 1,946
  • 7
  • 36
  • 54
2
votes
1 answer

Spring Integration Parallel Processing without Aggreagation

I couldn't find enough/clear documentation on this. I am getting a message from chain processing. Once the channel receives the message, I want to duplicate the message on conditional basis. Simple flow:
RaceBase
  • 18,428
  • 47
  • 141
  • 202
2
votes
2 answers

Duplicating Rows In DataGridView

The following code loads a tab delimited file into my DataGridView (loads 1 record from the data file). All this works perfectly, however, I need to duplicate this record X amount of times. Once the row is duplicated, I'll need to eventually edit…
Muhnamana
  • 1,014
  • 13
  • 34
  • 57
2
votes
2 answers

a maximum value per rowname(1, 2, or A, B..) per multiple columns in R

I want to a maximum value per rowname(1, 2, or A, B..) per multiple columns(samples). I have a matrix. id sample1 sample2 sample3 ... 1 16498 2416 12555.5 1 21282.5 3342 22202 2 18558 2308 na 2 17966 3047 na 2 398 176.5 na 3 347 227 201.5 3 604.5…
mkairs
  • 41
  • 4
2
votes
1 answer

TclLib C DLL, avoid Tcl_DuplicateObj, Called with Shared Object Error

I am writing a C DLL that creates a new command: Tcl_CreateObjCommand( interp, "work_on_dict", (Tcl_ObjCmdProc *)work_on_dict_cmd, (ClientData)NULL, (Tcl_CmdDeleteProc *)NULL ); The implementation of the command is: int work_on_dict_cmd( ClientData…
Zweikeks
  • 300
  • 1
  • 11
2
votes
4 answers

How to delete duplicate records in MySQL by retaining those fields with data in the duplicate item but not in the original item?

I have few thousands of records with few 100 fields in a MySQL Table. Some records are duplicates and are marked as such. Now while I can simply delete the dupes, I want to retain any other possible valuable non-null data which is not present in the…
ThinkCode
  • 7,841
  • 21
  • 73
  • 92
2
votes
2 answers

Remove duplicates from generic list

I have came with solution to remove duplicates from generic list in .NET 2.0 as follows: List caseStudies = CaseStudyDAO.FindCaseStudiesByDate(DateTime.Now.Date, DateTime.Now.Date.AddDays(1)); caseStudies.RemoveAll( …
Mariusz Miesiak
  • 638
  • 1
  • 6
  • 19
2
votes
2 answers

How to have at most n number of duplicates in a field

My question is somewhat unique I assume. Everybody wants to get rid of duplicates, but me on the other hand, I want to allow a specified number of duplicates to appear. I'm creating a database for reserving dates for Blood donation campaigns. My…
2
votes
2 answers

Avoiding Duplicate Data in DB (for use with Rails)

I have five tables that I am trying to get to work nicely together but may need some help. I have three main tables: accounts members and roles. With two join tables account_members and account_member_roles. The accounts and members table…
ants
  • 1,097
  • 1
  • 7
  • 13
2
votes
3 answers

obj-c duplicate symbol for header variable

It was my impression that using #import would only import a file once per build, yet after trying to define a variable in a header, and then importing that header in two different source files, I get a duplicate symbol linker error for the variable.…
quano
  • 18,812
  • 25
  • 97
  • 108
2
votes
3 answers

Extracting unique items from a list of mappings

He're an interesting problem that looks for the most Pythonic solution. Suppose I have a list of mappings {'id': id, 'url': url}. Some ids in the list are duplicate, and I want to create a new list, with all the duplicates removed. I came up with…
Eli Bendersky
  • 263,248
  • 89
  • 350
  • 412
Users