What I'm trying to achieve in MIP a query (SQL) to count / frequency of every feature in a string field
If we take a field called 'BOH_HistLith' (string field) I want to count each of the features in the field
Outcome would be how many/count of e.g.
Tlr = ?
Tls = ?
Au =?
And etc
The Calc Column statistic only works for integers
Would anyone please assist with a suggestion /script to use in MIP SQL query for this task?
Cheers, Mike
------------------------------
Mike Woodbury
Knowledge Community Shared Account
------------------------------