Databases
StackOverflow2013
Postsdbo
POHow can I remove rows with unique values? As in only keeping rows with duplicate values?
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POHow can I remove rows with unique values? As in only keeping rows with duplicate values?
    primarykey
    data
    text
    <p>Here's the conundrum, I'm a complete and utter noob when it comes to programming. I understand the basics, but am still learning javascript. </p> <p>I have a spreadsheet of surveys, in which I need to see how particular users have varied over time. As such, I need to disregard all rows with unique values in a particular column. The data looks like this:</p> <pre><code>Response Date Response_ID Account_ID Q.1 10/20/2011 12:03:43 PM 23655956 1168161 8 10/20/2011 03:52:57 PM 23660161 1168152 0 10/21/2011 10:55:54 AM 23672903 1166121 7 10/23/2011 04:28:16 PM 23694471 1144756 9 10/25/2011 06:30:52 AM 23732674 1167449 7 10/25/2011 07:52:28 AM 23734597 1087618 5 </code></pre> <p>I've found a way to do so in VBA, which sucks as I have to use excel, per below:</p> <pre><code> Sub Del_Unique() Application.ScreenUpdating = False Columns("B:B").Insert Shift:=xlToRight Columns("A:A").Copy Destination:=Columns("B:B") i = Application.CountIf(Range("A:A"), "&lt;&gt;") + 50 If i &gt; 65536 Then i = 65536 Do If Application.CountIf(Range("B:B"), Range("A" &amp; i)) = 1 Then Rows(i).Delete End If i = i - 1 Loop Until i = 0 Columns("B:B").Delete Application.ScreenUpdating = True End Sub </code></pre> <p>But that requires mucking about. I'd really like to do it in Google Spreadsheets with a script that won't have to be changed. Closest I can get is retrieving all duplicate user ids from the range, but can't associate that with the row. That code follows: function findDuplicatesInSelection() { var activeRange = SpreadsheetApp.getActiveRange(); var values = activeRange.getValues();</p> <pre><code> // values that appear at least once var once = {}; // values that appear at least twice var twice = {}; // values that appear at least twice, stored in a pretty fashion! var final = []; for (var i = 0; i &lt; values.length; i++) { var inner = values[i]; for (var j = 0; j &lt; inner.length; j++) { var cell = inner[j]; if (cell == "") continue; if (once.hasOwnProperty(cell)) { if (!twice.hasOwnProperty(cell)) { final.push(cell); } twice[cell] = 1; } else { once[cell] = 1; } } } if (final.length == 0) { Browser.msgBox("No duplicates found"); } else { Browser.msgBox("Duplicates are: " + final); } } </code></pre> <p>Anyhow, sorry if this is the wrong place or format, but half of what I've found so far has been from stack, I thought it was a good place to start. </p> <p>Thanks!</p>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. USHenrique G. Abreu
    1. USuser1456405
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    3. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POHow can I remove rows with unique values? As in only keeping rows with duplicate values?
      1. This table or related slice is empty.
      1. VTDownMod
    2. VO
      singulars
      1. POHow can I remove rows with unique values? As in only keeping rows with duplicate values?
      1. This table or related slice is empty.
      1. VTApproveEditSuggestion
    3. VO
      singulars
      1. POHow can I remove rows with unique values? As in only keeping rows with duplicate values?
      1. This table or related slice is empty.
      1. VTUpMod
    1. COJavascript is not Java....
      singulars
      1. POHow can I remove rows with unique values? As in only keeping rows with duplicate values?
      1. USRoddy of the Frozen Peas
    2. COYeah, thanks. I caught that in the tag, and forgot I typed it in the title. Like I said, new to this stuff.
      singulars
      1. POHow can I remove rows with unique values? As in only keeping rows with duplicate values?
      1. USuser1456405
    3. COI'm not sure a mis-tagged question warrant a vote-down.
      singulars
      1. POHow can I remove rows with unique values? As in only keeping rows with duplicate values?
      1. USPrisoner ZERO
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload