Skip to main content
Solved

Reduce duplicates, keeping uniques only

  • September 26, 2022
  • 3 replies
  • 12 views

scarter
Contributor
Forum|alt.badge.img+10

I have a table containing ten lines (each one a street). Each street has a name and a zone value. But there are some duplicate records…

 

Street_name                       Zone_name

St James Street                  Zone B

High Street                         Zone B

High Street                         Zone B

High Street                         Zone D

High Street                         Zone D

Acacia Avenue                   Zone B

Acacia Avenue                   Zone B

Acacia Avenue                   Zone B

Acacia Avenue                   Zone C

Acacia Avenue                   Zone C

 

How would I reduce these down to unique records only. So, I’d end up with this…

 

Street_name                       Zone_name

St James Street                  Zone B

High Street                         Zone B

High Street                         Zone D

Acacia Avenue                   Zone B

Acacia Avenue                   Zone C

 

 

Thanks,

Best answer by david_r

You can also consider the DuplicateFilter, set both Street_name and Zone_name as key attributes.

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

3 replies

redgeographics
Celebrity
Forum|alt.badge.img+59
  • Celebrity
  • 3698 replies
  • September 26, 2022

You could use a Sampler, set it to group by both attributes and then pass through only the first feature.


david_r
Celebrity
  • 8391 replies
  • Best Answer
  • September 26, 2022

You can also consider the DuplicateFilter, set both Street_name and Zone_name as key attributes.


scarter
Contributor
Forum|alt.badge.img+10
  • Author
  • Contributor
  • 125 replies
  • September 26, 2022

You can also consider the DuplicateFilter, set both Street_name and Zone_name as key attributes.

Thanks for that, David_R. It done the job. Regards, Stuart