We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.
We are currently experiencing an issue with Email verification at this time and working towards a solution. Should you encounter this issue, please click on the "Send Verification Button" a second time and the request should go through. If the issue still persists for you, please email support@alteryx.com for assistance.

Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback

Challenge #287: Find My Pet US

kelly_gilbert
12 - Quasar

 

My solution is similar to some of the others. See inside the spoiler for some performance analysis.

 

Spoiler
kelly_gilbert_3-1632763973860.png



I noticed that only a small percentage of the Pet and Owner records joined, so I wondered which would be better for run time: 1) using a Join Multiple to join all of the datasets together at once, or 2) filtering the rewards data first, to reduce the number of records in that join (since we only care about records where the reward is over the threshold). Option 2 is implemented above.

I made the datasets larger by generating additional Animal Ids (so each dataset had about 2.6 M records, with approximately the same join rate).

With 20 runs each, option 1 averaged about 25% faster than option 2 (but not significantly). 
Option 1: mean=8.9 s, stdev=1.34
Option 2: mean=12.2 s, stdev=1.51 

Michael_McKee
Alteryx
Alteryx

Fun.  Great way to start the week.

Spoiler
Capture.PNG

Alo_Erick
7 - Meteor
Spoiler
Alo_Erick_0-1632769273504.png

 

TonyA
Alteryx
Alteryx

Nice way to start the week.

Spoiler
TonyA_0-1632774056803.png

 

ryan-bush
Alteryx
Alteryx

I went with a Trade Area tool having a 500 mile radius followed by a Spatial Match, which seems to be unique to this thread. Is there a particular reason to go with the Distance Tool instead? A limitation that I wasn't considering?

 

Spoiler
287_Spoiler.PNG
barnap03
7 - Meteor
Spoiler
barnap03_0-1632776886951.png

 

Zas3nfkb
7 - Meteor
Spoiler
Weekly Challenge 9-27.jpg

Qiu
17 - Castor

It has been while for spatial challenge.

Spoiler
challenge_287.PNG
Jbone
7 - Meteor

My solution

 

Spoiler
Capture.PNG

perrysarah
5 - Atom

My solution