Skip to main content
Solved

Reduce duplicates, keeping uniques only

  • September 26, 2022
  • 3 replies
  • 9 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.

View original
Did this help you find an answer to your question?

3 replies

redgeographics
Celebrity
Forum|alt.badge.img+50

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


david_r
Celebrity
  • 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
  • September 26, 2022
david_r wrote:

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

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings