Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Weekly Challenges

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

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

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

SUBMIT YOUR IDEA

Challenge #287: Find My Pet US

François_Rs
8 - Asteroid
Spoiler
Franois_Rs_0-1674032226542.png

 

AngelPradeesh
6 - Meteoroid

In order to get the desired output the following steps should be followed:

 

1. Use a formula tool to replace currency symbol in the New_Pet Rewards field. You can use the formula " tonumber(replace([New_Pet Rewards],"$","")).

2. Use a select tool to then convert the data type of new_pet_rewards to a numeric data type. 

3. Use a filter tool to get all the amounts equal to and greater than 2700

4. Use a join tool to then match the outputs from pet info and the filter tool mentioned above using Animal ID as the common field. Use one more join tool to get common items from Owner_info as well.

5. Use "Create points tool " to get the centroid for from the long and lati from both the excels.

6. Use a "Distance" tool to get distance between the centroids in order to get the distance between the shelter and the owners house in miles.

7. Filter out the data to  get distance less than or equal to 500

8. Use the select tool to get all the desired fields as shown in the output.

 

Verakso
11 - Bolide

Another fun little challenge, here is my take at it:

Spoiler
2023-01-20 09_54_42-Alteryx Designer x64 - challenge_287_start_file.yxmd_.png


/Verakso (ツ)

Kusk
8 - Asteroid

Challenge Completed

RobbieA
8 - Asteroid

My solution to 287:

 

elaineyuan
8 - Asteroid

More spatial tool practice today. :)

 

Spoiler
challenge_287_elaine_yuan.png
jnpac
7 - Meteor

Spatial analytics is quite interesting and is new to me. I think it is exciting to learn!

 

jnpac_0-1676652773941.png

 

myastarling
10 - Fireball

Here's my solution.

Ed2000
8 - Asteroid
Spoiler
Ed2000_0-1678376005117.png

 

JoshuaGostick
11 - Bolide

My solution

 

Spoiler
challenge_287.PNG