Challenge #97: SANTALYTICS 2017 - Part 1

[SGolnik]

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]

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]

Easy png-easy. Took route 2.

Spoiler

[Laurap1228]

Spoiler

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]

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 fileThen unzip itThen load all of the images into a rowsetThen join them all together

[jasperlch]

This is a tough one! Solution attached.

[Natasha]

Spoiler

I used method #2 and a blob as we learned them just recently in Challenge #92! 

[JosephSerpis]

Challenge Completed

[Elena_Caric]

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