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
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 #97: SANTALYTICS 2017 - Part 1

SGolnik
11 - Bolide

I admit this one was over my head. I did it, but I used the community posts to accomplish it as I had never used the download tool or the image tool before. This was a great learning opportunity for me though and for that I thank you! 

Philip
12 - Quasar

Sadly, I can't take part in Satalytics this year because our systems are still 11.0 and I can't open the files. Good to see so many participating, though!

lminors
9 - Comet

Easy png-easy. Took route 2.

 

Spoiler
WC97.JPG
Laurap1228
9 - Comet

 

Spoiler
challenge97part1.jpg

I went with option 1 with a little help from the following post:

 

https://community.alteryx.com/t5/Data-Preparation-Blending/Can-Alteryx-unzip-a-file-as-part-of-the-w...

SeanAdams
16 - Nebula
16 - Nebula

Great challenge, and hopefully a few options for @TaraM to help with the next iteration of the Periodic table!

 

Did both options for good measure.

 

Spoiler

The key for me was wrapping each of these pieces in a Batch Macro to ensure that they run in a series - this allows you to avoid the issue that many faced that they had to disable the downloader when creating the report version

First download the zip fileFirst download the zip fileThen unzip itThen unzip itThen load all of the images into a rowsetThen load all of the images into a rowsetThen join them all togetherThen join them all together

 

jasperlch
12 - Quasar

This is a tough one! Solution attached.

Natasha
9 - Comet
Spoiler
I used method #2 and a blob as we learned them just recently in Challenge #92! Screen Shot 2018-01-07 at 22.50.47.png
ReinierK
7 - Meteor
 
JosephSerpis
15 - Aurora
15 - Aurora

Challenge Completed

Elena_Caric
8 - Asteroid

Deceiving by the looks of it, but the workflow took so much time. Good practice though