Skip to main content
  • EN

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,

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

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

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

Reply


Community Stats

30,162
Posts
114,512
Replies
37,820
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.