python (65.1k questions)

javascript (44.2k questions)

reactjs (22.7k questions)

java (20.8k questions)

c# (17.4k questions)

html (16.3k questions)

r (13.7k questions)

android (12.9k questions)

Questions - duplicates

How to populate rows based on the number required in google sheet?

Hi all, I want to use a formula to duplicate the department name based on the number of employee in the department. For example. there are 2 employee in Finance department, so the formula will duplic...
test-img

weizer

duplicates

google-sheets-formula

array-formulas

Votes: 0

Answers: 2

Latest Answer

use: =INDEX(FLATTEN(TRIM(SPLIT(QUERY(REPT(B3:B&"♦",C3:C),,9^9),"♦"))))
test-img

player0

replace and remove duplicate rows using ifelse

I have a data frame of postcodes with a regional/metro classification assigned. In some instances, due to the datasource, the same postcode will occur with both a regional and metro classification. ...
test-img

bambi

r

if-statement

duplicates

Votes: 0

Answers: 2

Latest Answer

Based on your title, you're looking for an ifelse() solution; perhaps this will suit? PC_ACTM <- structure(list(POSTCODE = c(3000L, 3000L, 3256L, 3145L), REGION = c("...
test-img

jared_mamrot

How to Remove Duplicate with precedence of a particular field in mysql select query?

I've a mysql query which returns few records with duplicates. I need to get the unique record when both "Success" and "Error" exist in mysql result set and it should consider only ...
test-img

Partha

mysql

sql

select

group-by

duplicates

Votes: 0

Answers: 1

Latest Answer

I suggest using select select max(status) as 'Status', that could do the job of getting first the status 'Success'. Then we can use group by job_logid,job_name to preserve the duplicates from the one ...
test-img

David Valladares L.

Find duplicate values inside an array of objects in MongoDB in single record

I'm new to making queries in Mongo. I have this single record and I need to find the sections with the same link. My record: { "_id" : ObjectId("1234"), "name": &...
test-img

Juan Manuel

arrays

mongodb

mongodb-query

duplicates

nosql-aggregation

Votes: 0

Answers: 2

Latest Answer

Edit: You can use $group: db.collection.aggregate([ {$unwind: "$sections"}, { $group: { _id: "$sections.link", orig_id: {$first: "$sections._id" }, ...
test-img

nimrod serok

Posts

Questions

Blogs

Jobs