I have 8 fields that can possibly be filled with data. I want to grab data from the last field that has data and the coalesce function seems to be the best way to do that but it only works with 2 fields. Is there anyway to do that calculation with more than 2 fields?
You can nest the coalesce functions, ensuring that your brackets are all closed and the values are listed in reverse order so that they are checked for values in the order you stated in the question.
coalesce(${TestArea8}, coalesce(${TestArea7}, coalesce(${TestArea6}, coalesce(${TestArea5}, coalesce(${TestArea4}, coalesce(${TestArea3}, coalesce(${TestArea2},${TestArea1})))))))
Signed in members can post, follow updates, and more. New here? Register a free account.
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.
