Skip to main content
  • EN

how should I do if I want to pick out the userID with 1 row only. For example

USerID Long Lat Count

 

001 1 1 20

 

001 2 2 1

 

002 3 3 5

 

003 4 4 20

 

003 5 5 6

 

004 6 6 9

 

I need to pick out the userID 002 and 004 and keep all attributes

Hi @s3585629, the StatisticsCalculator could be an easy way.

Hi @s3585629, the StatisticsCalculator could be an easy way.

Thank @takashi. I tried the StatisticsCalculator but the output contain only UserID and _count, not as my wish. I used FeatureCount then Test with count=1 then it works

 

Hi @s3585629, the StatisticsCalculator could be an easy way.

I suspect that you are looking at the features output from the Summary port of the StatisticsCalculator. Have a look at the features output from the Complete port.

 

 

Hi @s3585629, the StatisticsCalculator could be an easy way.

Wow, my mis-reading. Thx Takashi

 

 

Reply


Community Stats

31,819
Posts
120,860
Replies
39,451
Members

Latest FME

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.