This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!
Submit FeedbackFun challenge! Great spatial practice!
Wish this Challenge had a more less manual approach(of building a lookup).
Apparently trying a logical approach for this opens up a can of worms 😄
Cheers and Happy Analyzing 🙂
I tried so hard initially to do this dynamically before "borrowing" a formula tool from @hanykowska (hope that's ok!) Video solution here: https://www.youtube.com/watch?v=QGpINYI6xRo&list=PL18SpOXDj-KMUD4YwWC5vZaUsIa7drxNZ&index=25&t=0s
Great challenge.
I took the liberty to include another output which includes whole farm data as a record with the rest of the fields.