Skip to main content
Question

find the maximum amount of field name that repeated then change the whole attribute included to this name with same id

  • February 17, 2020
  • 3 replies
  • 20 views
gogopotter90
Contributor
Forum|alt.badge.img+14

Hi Guys ,

Iam so confused about something and i hope if someone give me a good solution

 

i have different names but i want to force the attribute to change different names even repeated or not for the name that repeated too much .

as example TOM is repeated around 5 times so i want the whole attribute name change to TOM with the same id

i tried some condition in attribute manager with static calculators but it seems does not work to me .

 

my target ,it should looks like it

 

Hint not all the time the id will looks like counter ,it almost random

 

Thanks in advance

 

 

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

takashi
Celebrity
  • takashiCelebrity
  • 7843 replies
  • February 17, 2020

Hi @gogopotter90, if you need to replace "name" for every row with the mode (the most frequent value) of them, you can use the StatisticsCalculator with this setting. Your required features will be output from the Complete port.

Why not inspect features with Visual/Data Preview and Feature/Record Information before writing them into a destination dataset?
ebygomm
Influencer
Forum|alt.badge.img+44
  • ebygommInfluencer
  • Influencer
  • 3427 replies
  • February 17, 2020

Will you ever have two names that occur at the same frequency?

gogopotter90
Contributor
Forum|alt.badge.img+14
  • gogopotter90Contributor
  • Author
  • Contributor
  • 239 replies
  • February 17, 2020

Hi @gogopotter90, if you need to replace "name" for every row with the mode (the most frequent value) of them, you can use the StatisticsCalculator with this setting. Your required features will be output from the Complete port.

Thanks alot ,it works perfect but could i ask ,why i got my output from complete not from summart ,bcs honestly iam always using summary but it is first time i got my output from complete,just as information and thanks again for ur method

Community Stats

32,076
Posts
121,800
Replies
39,707
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement
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.