Hello All, I am new in Arcade so I am wondering if I can generate Unique Codes in a field based on categories.
So for example, Lets say I am working on a Local Government layer, which has a STATE column. I want to learn a procedure or an Arcade Expression that can generate serialized code that begins from "0001" to the highest number of Local Government for each state.
so if Bayelsa State has eight Local governments and Kano has 44 Local Governments, the UniqueCode field should be populated with code such as ( for Bayelsa: BY0001 to BY0008) and (for Kano: KN0001 to KN0044).
Thank you
