This tag is for questions involving values which are only one of its kind; unlike anything else.
Questions tagged [unique-values]
173 questions
0
votes
3 answers
How to get unique values in multiple left join
I have the following code I have to join 3 tables but Dest.Code has has repeated values. How can I get unique values for Dest.Code?
I have tried DISTINCT but doesn't work.
SELECT
Dest.Code
,City.CityName
,Country.Id
FROM base.Dest
Left…
db_noob
- 119
- 2
- 11
0
votes
1 answer
What is causing the error in the formula =NETWORKDAYS.INTL(JANEIRO!A2;C2;"1";FEVEREIRO!A2;C2;"1") to count only Mondays, and how can it be fixed?
When using the formula =NETWORKDAYS.INTL(JANEIRO!A2;C2;"1";FEVEREIRO!A2;C2;"1") to count only Mondays in the January and February columns A and C sheets, I'm encountering an error. What is causing this error, and how can I modify the formula to…
Glaucco
- 47
- 5
0
votes
0 answers
value ranking based on multiple criteria
I Need to rank Dealers based on their Sales value and in regards to the Group and Country they belong to per month. It should look like this:
DealerID Month Country Group SalesValue Ranking
12344 1 Germany Sales 120 1
23345 1 …
Johnny
- 1
0
votes
2 answers
MYSQL in phpmyadmin uniqueid primarykey duplicate id numbers
I have multiple tables that don't have indexes nor primary key after migration.
There are 9149 entries in some tables and about 10 new entries have been given id = 0.
I can't give primary key due to multiple entries with same id, and I can't edit…
Matt
- 1
0
votes
1 answer
uniquerValues - view is required to query stats from layerView" and feature-layer-adapter:insufficient-data
I'm trying to make use of uniqueValues function from ESRI ArcGIS for JavaScript 4.10.
However, it's failing with this message:
message: "view is required to query stats from layerView" name:
"feature-layer-adapter:insufficient-data"
I have a…
Leniel Maccaferri
- 100,159
- 46
- 371
- 480
0
votes
2 answers
MS Access How to Count Unique Records or Values On a Filtered Report
All,
I have a query called "WCR_Q" and a report called "WCR_R" based off of this query. My report is filtered based off a record selection from a form. When I use the expression =Count[FacilityID] becuse I get a total number of records in the…
Jason Steward
- 39
- 1
- 10
0
votes
1 answer
random selected dictionary values checked and restarted if matched
So I am creating a text-based Murder Mystery Game for Learn Python the Hard Way... So this is probably really simple but I can't figure it out.
Essentially I am choosing the location of clues, there are 16 options, 4 large locations, and 4…
Cameron Herritt
- 33
- 6
0
votes
1 answer
How to extract unique values from a data frame column?
I've been trying to create a function that extracts the unique values of a given column in a given data frame, by writing this code:
val_uniques <- function(colname, datframe)
if colname %in% colnames(dataframe) {
print(unique(dataframe[,…
Nabil
- 19
- 1
0
votes
1 answer
Trying to remove certain duplicate values in excel
I have a data set of orders that are all linked by a primary key (batch number). However the order numbers have a field marking if they were on time or late. If one order number is marked late the whole batch number should be marked as late, and…
jh144
- 25
- 1
- 5
0
votes
0 answers
insert random values into sql table
I'm trying to insert four random values into my sql table TRandomCodes. I've never tried this but below is the table I'm trying to insert the random values into. The random values I want to insert are at intRandomCodeID 21.
INSERT INTO TRandomCodes…
NoLuckCollector
- 65
- 8
0
votes
2 answers
Excel VBA - Getting a list of unique entries across various columns and combine into a single column of unique items
I am trying to get a list of unique data from multiple columns into a single column.
I found the following code which works great;
RanglFilterCopy, CopyToRange:=Range("B1"), Uniqe("A1:A6").AdvancedFilter Action:=xue:=True
Source of this was (and…
Peter Mole
- 1
- 1
- 3
0
votes
1 answer
Excel: Extract unique values from column using multiple criteria
I have a sheet in excel with a list of names, values and dates.
I'm trying to extract unique values from that list, but filtering them considering the "date" column first.
Image below is manually edited to show how it should work:
As of now, I'm…
Javier C
- 25
- 1
- 10
0
votes
2 answers
Error in For Each loop using AutoFilter runtime (error 13)
This is what I am trying to do
Find unique values in column D
Loop over those values by creating a filter with each
with the remaining rows after filtering, I do the same with columns E and F.
Finally, I just need to copy the remaining values…
Pablo Bonilla
- 15
- 4
0
votes
2 answers
Find lowest value in column for every unique 2 values in other columns Matlab
I have a matrix, a small sample of the data:
A=
1 3 658
2 3 475
5 3 769
1 3 856
6 7 1579
2 3 678
5 3 118
6 7 617
So now, I want to find for every unique combination of column A and B the lowest value in column C, preferably in a new…
Rogier
- 65
- 1
- 6
0
votes
0 answers
Compare list of values in a field with values in a column
I have two tables that I want to compare but with a twist. One table have all our projects and the other have all the Project Issue statuses.
The Project table have a list of Projects and besides the obvious columns we have a column with assigned…
Erik
- 1