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