I have a transformer that pulls data and returns something like this:
All values in the _count column should be the same. How would I go about determining if there is more than one unique value?
Solved
How can I determine if the value in a column is the same for all rows
+10- Contributor
Best answer by ebygomm
The Statistics Calculator has a Value Count option which will count the number of values. Just check the calculation method (string v numeric) and be aware that this won’t count nulls or missing, i.e. if you have 3 records with a _count of 9 and one where _count is null the value_count result will be 1
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.
+21- Influencer
The simplest way would be to use a Tester (_count=9). Unless your _count can have other values, in which case you can use several options. Calculate the statistics for example, or use the AttributeManager with adjacent feature checking enabled, or even a DuplicateFilter. I think I would use the StatisticsCalculator.
+10- Contributor
Yes, unfortunately the _count value will change. If I use the StatisticsCalculator, would I then just put a Tester transformer after it to check if the summary output is > 1?
+45- Influencer
- Best Answer
The Statistics Calculator has a Value Count option which will count the number of values. Just check the calculation method (string v numeric) and be aware that this won’t count nulls or missing, i.e. if you have 3 records with a _count of 9 and one where _count is null the value_count result will be 1
