Hello guys I want to delete entire row with single entry Input: NameIDDateGradeAlyssa12021-01-224Alyssa262021-02-055Alyssa452021-01-084Dy62021-01-224Edrose332021-02-055Fatima92021-01-225Fatima372021-02-055 Desired Output: NameIDDateGradeAlyssa12021-01-224Alyssa262021-02-055Alyssa452021-01-084Fatima92021-01-225Fatima372021-02-055

Remove not duplicates

Hello guys I want to delete entire row with single entry

Input:

Name	ID	Date	Grade
Alyssa	1	2021-01-22	4
Alyssa	26	2021-02-05	5
Alyssa	45	2021-01-08	4
Dy	6	2021-01-22	4
Edrose	33	2021-02-05	5
Fatima	9	2021-01-22	5
Fatima	37	2021-02-05	5

Desired Output:

Name	ID	Date	Grade
Alyssa	1	2021-01-22	4
Alyssa	26	2021-02-05	5
Alyssa	45	2021-01-08	4
Fatima	9	2021-01-22	5
Fatima	37	2021-02-05	5

Transformation

Accepted answers

Emil_Kos

Hi @Ultralightbeam,

I have prepared a workflow for you:

I am checking how many times the name is occurring in the data and we removed everything that occurred only once.

If this workflow is helpful please mark my post as a solution.

Filter out.yxmd

All comments

echuong1

You can use the Only Unique Crew macro. The non-duplicates will come out of the U, and duplicates out of the D.

New Workflow1.yxzp

Emil_Kos

Hi @Ultralightbeam,

I have prepared a workflow for you:

I am checking how many times the name is occurring in the data and we removed everything that occurred only once.

If this workflow is helpful please mark my post as a solution.

Filter out.yxmd

apathetichell

Summarzie tool (Group by Name, Count Name). Join the results to your original database with Count as a new column. Filter by Count > 1. That should give you what you need.

Ultralightbeam

Hi @Emil_Kos, I forgot the main issue why I posted this.

Input:

Name	Provider	Date	Grade
Alyssa	Nico	2021-01-22	4
Alyssa	Shaira	2021-01-22	5
Alyssa	Shaira	2021-02-05	5
Alyssa	Nico	2021-01-08	4
Dy	Nico	2021-01-22	4
Edrose	Nico	2021-02-05	5
Fatima	Shaira	2021-01-22	5
Fatima	Nico	2021-02-05	5

Desired Output:

Name	Provider	Date	Grade
Alyssa	Shaira	2021-01-22	5
Alyssa	Shaira	2021-02-05	5
Alyssa	Nico	2021-01-08	4
Fatima	Shaira	2021-01-22	5
Fatima	Nico	2021-02-05	5

so if the name has two provider, it should get the max grade.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703