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
Solved
Remove user with more than 1 row
Best answer by takashi
Hi @s3585629, the StatisticsCalculator could be an easy way.
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.
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.
Hi @s3585629, the StatisticsCalculator could be an easy way.
- 7843 replies
Hi @s3585629, the StatisticsCalculator could be an easy way.