Solved

Remove user with more than 1 row

S
Badge

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
icon

Best answer by takashi 12 May 2018, 12:40

View original

4 replies

takashi
Rank
Userlevel 2
Badge +17

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

S
Badge

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

 

takashi
Rank
Userlevel 2
Badge +17

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.

 

 

S
Badge

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

Wow, my mis-reading. Thx Takashi

 

 

Reply


Community Stats

28,706
Posts
109,463
Replies
36,550
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.