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
  • 10 views
gogopotter90
Contributor
Forum|alt.badge.img+13

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

 

 

1 Attachments

3 replies

takashi
Evangelist
  • takashiEvangelist
  • 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.

ebygomm
Influencer
Forum|alt.badge.img+39
  • ebygommInfluencer
  • Influencer
  • February 17, 2020

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

gogopotter90
Contributor
Forum|alt.badge.img+13
  • gogopotter90Contributor
  • Author
  • Contributor
  • February 17, 2020
takashi wrote:

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

Reply


Helpful Members This Week

Community Stats

31,545
Posts
119,582
Replies
39,182
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement

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
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.