Weekly Challenge

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

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

Submit Feedback
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.

Challenge #145: SANTALYTICS 2018 - Part 1

Highlighted
7 - Meteor

I would pick the second non profit (Denver Scholarship Foundation) since they have a longer history. I pulled three years worth of data (per the Efficiency calculation). 

Spoiler
Santa Part 1.JPG

 

 

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

I'm glad I challenged myself to do this with only the URLs provided as the input and not download any files.

 

Spoiler
The Excel file was the only tricky part. I used the Download tool to write the file as a temporary file and changed the file name back to the '17eofinextractdoc.xls' provided by the URL so the Dynamic Input would be happy with the file extension. I didn't think of a way to handle for the '990' sheet name easily, so that was just hard coded
Highlighted
8 - Asteroid

Solved. However, I am getting different results (on the sorted output) that what others did - not sure why. 

 

Also, added my state to the mix.

 

Spoiler
alteryx-c145.PNG
Highlighted
Alteryx Certified Partner

Took me a few hours to figure out the excel sheet issue! I definitely used the help of some more experienced alateryx'rs. This one took me for a loop! 

 

By seeing another alteryx user use the dynamic rename tool, I took it on. it was fun to see that in action!

 

Also, I don't have the greatest computer in the world, but, I now understand why making your workflow efficient is important..... by the end it was taking me 12-16 seconds to run this puppy! I believe mainly because of the downloading aspect, I will be practicing downloading the file loacally, it would have helped!

Spoiler
capture8.PNG
Highlighted
Alteryx Community Team
Alteryx Community Team

@AGoyal I think yours sorts differently because you created your AFE column as a string instead of a number.

16 - Nebula
16 - Nebula
Spoiler
2018-12-10_23-47-03.png
Highlighted
14 - Magnetar
14 - Magnetar

My solve.... Revamped for downloading data directly from the websites. Thanks to @CharlieS for figuring out how to do all of that.

Highlighted
12 - Quasar

My Solution:

 

Spoiler

A Precious Child Inc.

Capture.PNG



And extra credit...

 

Spoiler
... still having fun with this data and working on it!

 

 

Highlighted
12 - Quasar
12 - Quasar

Love Santalytics every year!  I looked up Ohio to see what ranked tops there as well.

The website wouldn't accept the yxzp for exceeding the maximum size.  Here's my workflow.

Highlighted
8 - Asteroid

my solution: 

 

Spoiler
Spolirer_145_SP.PNG