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?
Page 1 / 1
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.
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?
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