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

Prevent duplicate entries in a ms access table

I am new to ms access, I have prepared a database for a school where I want to apply duplicate entry restrictions. I want to stop duplicate entry in same month. Type of studentID is number while the month is linked with another table where its type…
Shakir
  • 1
0
votes
0 answers

VBA Extract Unique Values with Advance Filter From One Worksheet to Another

So I have this Workbook contains several worksheets. In Sheet22 is a database and I need to extract unique values from one of its columns, which is Column "BC" (or Col 55). here is to illustrate the unique values that I want to extract: I need to…
Agatha Rona
  • 11
  • 2
0
votes
1 answer

How to rename all columns with count 1 as 'others'

I am classifying movies by genres . ( Action Adventure SciFi, Thriller Horror Action ,...) so on. I get 200 classes and of that 50 classes have only one value when I groupby. I want to rename each of these rows by value (or occurence=1 each) and…
tom786
  • 3
  • 2
0
votes
1 answer

PowerShell return multiple values from if condition

I have a Powershell script returning data from an API which works fine as long as I only attempt to return one $device.realm, but I need multiple realms. I'm a newb to PS. Any help here is really appreciated Here is my code $Output = forEach…
lito
  • 3
  • 1
0
votes
1 answer

Find the SUMPRODUCT of all unique values of a specific column?

The math is simple. First match up all the units and their respective unit cost per invoice number. Multiply each unit by the unit cost and then find the SUMPRODUCT of each unique invoice number. Here is what I have so far done. I can find the…
RobLaw
  • 3
  • 2
0
votes
1 answer

calculate unique identifier for record comparison

I have a table that stores imported data. Upon each import I need to check if an imported item already exists. I use a unique ID for this and it works fine. BUT the reason for the match could be that the same record is being imported (there are no…
Lester Lane
  • 3
  • 4
0
votes
1 answer

unique values in categorical variables R estudio

How can I find how many unique values each categorical takes in a data frame and then represent it with a graph? all this in R studio
Manuel Ramírez
  • 1
0
votes
1 answer

Complex deletion of repeated elements within groups from array

I have the following input data, for which I'd like to remove repeated elements (leaving all strings in the same order of appearence) within each group and each sub group. A group begins with a string that has related s5, in this case all below…
Ger Cas
  • 2,188
  • 2
  • 18
  • 45
0
votes
1 answer

Is there an R function to delete duplicate values within a cell for a large dataset?

I have a large dataset and my problem is the following: I have multiple entries within a cell. I want to delete the duplicates within cells, but keep the duplicate row entries for all columns. Here is an example Code that will lead so a situation…
Thisonesecret
  • 21
  • 1
0
votes
2 answers

Showing value as percentage incorrectly in PowerBI

I have added a table to my power BI dashboard and my accuracy column showing results as percentage of grand total.But as the image the percentage is showing incorrectly and my measure is correctly done.when i set the values as no calculation is…
Mishi
  • 55
  • 1
  • 2
  • 12
0
votes
0 answers

value frequency as a column after group by

I am trying to mark the frequency of identical value (year) in a dataframe and to show it as a column in the original dataframe. Prior to that I need to group all the rows based on another column. This is dummy data, in principle, I have many more…
Olya_n
  • 1
0
votes
1 answer

Spotfire - Filtering a Table by Values in a Calculated Column

I am trying to filter a table visualization of all of my data by looking to see if a Study Number contains Activity A. If a Study Number contains Activity A then I want to filter for all rows containing those Study Numbers even if the Activity is…
Victoria Grant
  • 35
  • 4
0
votes
3 answers

What's The Best Way To Remove Duplicate Rows Based On A Row Item In A DataTable With VB.Net?

I can't figure out how to do this after reading multiple posts on the internet and I would just like to make a very clear post below about this problem. I will remove the post if I am pointed to a article with the same question that helps me. I…
Mark
  • 178
  • 1
  • 2
  • 16
0
votes
2 answers

I want all unique array value together in one field from mongodb

I am using MongoDB. and I have multiple fields in documents of one collection, which are color, style, keywords, shape, etc. and all data type is an Array. I want all the unique values of color, style, shape, keywords, etc. from all the…
Yellow Digital Labs
  • 256
  • 6
  • 17
0
votes
2 answers

VBA Unique values

I'm trying to find all unique values in column A copy the unique items to a collection and then paste the unique items to another sheet. The range will be dynamic. So far I've got the code below, it fails to copy the values to a collection and I…
Carlsberg789
  • 145
  • 1
  • 11
1 2 3
…
11 12