Stack Overflow
Stack Overflow

Questions tagged [unique-values]

This tag is for questions involving values which are only one of its kind; unlike anything else.

173 questions
0
votes
2 answers

generating all the non-unique values from one column in spreadsheet

I have this form of spreadsheet A ABC DEF GHI FOO BAR BAZ ABC Of-course that the table is much much longer. I want to insert more values, but I want to validate their uniqueness first. In another words, whenever I insert a value that already exist…
Yair Saban
  • 95
  • 1
  • 1
  • 9
0
votes
2 answers

SQL Server getting unique values for each product

I'm trying to make a query where it doesn't include products that have the same discount percent as another product. I'm also suppose to use a subquery. This is what I've came up with but I'm getting an error saying, "Subquery returned more than 1…
jaramore
  • 389
  • 1
  • 3
  • 12
0
votes
1 answer

How do I get a list of unique values from a column in Excel VBA?

I've gone through many different articles that filter unique values; however almost all of them copy to a new location / loop through the entire column manually which I would like to avoid doing. My requirement is to separate the rows from a single…
Nilay Panchal
  • 541
  • 6
  • 17
0
votes
2 answers

MySQL return set if values don't exist

Let's say I have 5 rows, containing the following: ID KEY VALUE 1 address 123 Main Street 1 latlng (111.139, 111.238) 2 address 45 South Street 3 address 67 North Ave 3 latlng (448.002,…
f8xmulder
  • 347
  • 1
  • 6
  • 17
0
votes
1 answer

Unique values in multidimensional array

I am looking for a way to remove duplicated values from a multidimensional array Example String[][] values = [["A","A"],["A","A"],["B","B"],["B","B"]] String[][] dupsRemoved = ? println dupsRemoved DESIRED OUTPUT [["A","A"],["B","B"]]
user955732
  • 1,330
  • 3
  • 21
  • 48
0
votes
2 answers

append three variables from the same dataset SAS

I want to create a variable which would have unique values of each variable present in the dataset. I have a dataset with three variables and some unique values in each of them. Example: var1 Var2 Var3 1 4 5 1 3 7 2 8 6 3 …
user2964348
  • 3
  • 1
0
votes
2 answers

Python: eliminate duplicate nested lists

I am building a tagging model for natural language processing. Initially, the words of a sentence are tagged as a part of speech (like NN for noun), then the rules are applied that divide them into trees which are represented as nested lists. This…
GenericJam
  • 2,915
  • 5
  • 31
  • 33
0
votes
2 answers

Identify unique string values among lists of elements

I have an unbalanced, large dataset where each observation can take multiple string values, each stored in a separate variable: obs year var1 var2 var3 newval 1 1990 str1 str2 str3 3 1 1991 str1 str4 …
Deni M
  • 1
  • 2
0
votes
1 answer

Finding the unique values in MySQL by few columns

So, i have the following structure of my table: id user_agent user_ip --------------------- 18 Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.4 (KHTML, like Gecko) Chrome/22.0.1229.94 Safari/537.4 4.3.2.1 13 Mozilla/5.0 (Windows NT 6.2;…
getjump
  • 11
  • 4
0
votes
1 answer

finding values without a loop in R

I have one vector v, created with c(), that has this data: v[a,b,d,z,e,f], it must be unordered And I have a txt file with the form: label 1 2 3 .... b 100 2000 15 z 123…
Layla
  • 5,234
  • 15
  • 51
  • 66
-1
votes
1 answer

How to find unique rows from table sqlite android?

How can i get the unique rows from a table in sqlite database android
Satheesh Guduri
  • 353
  • 4
  • 8
-1
votes
2 answers

How do I get unique values of one column based on another column using the insert database query in Anylogic?

How do I get unique values of one column based on another column using the query? I tried using (double)selectFrom(tasks).where(tasks.tasks_type.eq()).uniqueResult(tasks.task_cycle_time_hr); I want to automate this and make sure that all the values…
user17690604
  • 11
  • 1
-1
votes
1 answer

Javascript equivalent of array_unique in PHP

I've been looking for a native javascript function which represents the equivalent of PHP's $Fruit_Bowl = array_unique($Fruit_Bowl); I can recreate this myself, using a pair of nested loops: the outer loop counts down through the array the inner…
Rounin
  • 27,134
  • 9
  • 83
  • 108
-1
votes
4 answers

Python List and count all unique values in list

I have a list: originalList = ['Item1', 'Item1', 'Item1', 'Item2', 'Item2', 'Item3', 'Item4'] I need to create two lists based off of the originalList The first list I need, should list all unique items, such as: ['Item1', 'Item2', 'Item3',…
Llewellyn Hattingh
  • 306
  • 1
  • 5
  • 16
-1
votes
1 answer

Compare two columns - get only unique values from second column

I'm looking for a tool/script that could help me to get only unique values when comparing two columns, and only unique values from second column. For example, if data is: column1: aa bb cc column2: aab bb ccd In this case I would like to see in…
Edvinas Perminas
  • 33
  • 1
  • 8
1 2 3
…
11
12