Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAFun 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.