Skip to main content
  • EN

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

 

 

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.

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

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


Community Stats

30,176
Posts
114,542
Replies
37,835
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.