Questions tagged [unique]
Refers to an element that is distinctly different from any other element in a collection.
unique
6,164
questions
1
vote
1
answer
65
views
Delphi: check if values in array (or values of variables) are unique at one time
I need to check if values of some variables are unique. This is a sample/example for 4 variables, but i'm looking for something universal so that it works for 3, 5 and so on variables. I can make a ...
- 301
0
votes
0
answers
15
views
How can I find all unique sub graphs within a graph database such as memgraph?
I have a dataset of tens of thousands of directed subgraphs. The subgraphs are trees, they branch from the root node and never merge. I want to find all the unique subgraphs based on the event_type ...
-3
votes
0
answers
19
views
Creating a random unique id in MySQL [duplicate]
I want a user ID with AUTO-INCREMENT AND a user code using UUID()
I want to verify that this will work properly without duplicating any user codes.
Thanks guys!
CREATE TABLE IF NOT EXISTS `accounts` (
...
2
votes
4
answers
89
views
Using Excel O365, How to use unique on two columns, sort, and copy over related data?
I have a 4 column, dynamic row array with names, process, order #, and dates. The array is dynamic and being collected using FILTER() function and grabbing the 4 columns I want from a table on a ...
- 23
2
votes
1
answer
47
views
number every first unique piece in each group
In each group, each 1st unique item should be given a different number in new column 'num'.
I can form the groups but I don't know how to number the unique pieces.
Is there a way to do that ?
Unique ...
- 57
-1
votes
0
answers
7
views
Table Table1 Column Type does not have a unique name' when generating xlsx file from csv file
We are facing a very odd issue in our production environment. The service using the EPPlus library to generate an excel file with multi tab works fine, but randomly it throws an error message ...
0
votes
2
answers
80
views
Windows Batch - How do I create an array with a unique set of values?
I'm messing around in Batch and writing code that loops through files in a directory and adds the last four characters of the file name to an array. The problem is that there are duplicates in my ...
- 45
-3
votes
2
answers
82
views
Counting number of unique values in one column if data in a 2nd column matches anything in a 3rd column
I have data that will be changing daily.
I'd simply like to get a count of unique values from the first column if the data in the same row of the 2nd column matches anything in the 3rd column located ...
0
votes
1
answer
54
views
Count If Meets Multiple Criteria and Unique
I have read several other relatable questions with responses, including referenced suggestions, but they do not appear to be similar in my requirements or I'm having troubles understanding what they'...
- 65
0
votes
0
answers
17
views
Sqlalchemy keep encrypting while keep field unique
Which I want a value been encrypted when commit to table. Then query with clear text.
I read the sqlalchemey wiki. By using typedecorator, it worked well.
However, how to keep clear text unique giver ...
0
votes
0
answers
35
views
How To Count Unique Values in a Filtered List in Excel
I have a large table in excel with 20+ headings.
I am filtering the list based on a heading in Column Z.
I want to find the number of unique serial numbers that are defined in Column O.
I filtered the ...
0
votes
0
answers
23
views
Pull unique lists from multiple tabs with dynamic row and column ranges
I have the attached file, where there are 2 "animals" tabs that I would like to extract unique lists from.
https://docs.google.com/spreadsheets/d/1rycpqCRCFJdqaWea624_BHvJnntB9WWZ/edit?gid=...
1
vote
4
answers
98
views
How to get string with disctinct (unique) characters from existing string in bash script?
For example, I have string:
explicit_borders="\"\"''()"
How to calculate based on this string the string with the following result:
distinct_border_chars="\"'()" # ...
- 1,064
3
votes
3
answers
105
views
Finding unique columns and their indices in NumPy matrix efficiently
I have a very large binary matrix (for example, shape = (210000, 5000)) and want to find unique columns and indices of this matrix. Memory is important to me, so that is why I am looking for a method ...
- 31
-1
votes
2
answers
85
views
Changing value in one column with sequential information when cell value changes in another column
Cannot find information on web, so asking for help. All solutions I find are on python. I need solution on google sheets.
I have sequential information, which needs to be updated based on values in ...
