Skip to main content
  • 4,045 Posts
  • 13,979 Replies
4045 Posts
Reduce duplicates, keeping uniques only

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_nameSt James Street                  Zone BHigh Street                         Zone BHigh Street                         Zone BHigh Street                         Zone DHigh Street                         Zone DAcacia Avenue                   Zone BAcacia 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_nameSt James Street                  Zone BHigh Street                         Zone BHigh Street                         Zone D

Badge Winners

  • Welcome Back
    okainunoohas earned the badge Welcome Back
  • FME Flow Certified Professional
    kruti_811has earned the badge FME Flow Certified Professional
  • FME Certified Professional
    bkjhas earned the badge FME Certified Professional
  • Expert (Bronze)
    timatsafehas earned the badge Expert (Bronze)
  • FME Form Advanced Training
    mike_greshhas earned the badge FME Form Advanced Training
Show all badges

Community Stats

32,431
Posts
123,238
Replies
40,558
Members