It's building time in ‘alteryx-ese’ first we download data and p-n-gs! Santa's orders are stacked too high!! How can we help keep the periodic table of Alteryx tools orders coming year after year? Automation in Alteryx, of course! First, we'll need image assets to create our unique periodic tables. If you are just checking out #SANTALYTICS for the first time, please read our intro blog to see our team rap, learn about the badge, and maybe get a shot at some SWAG! Goal: * Download image assets to make your periodic table visual from the web: * You can try two different paths:* Download the .zip file and extract using an Alteryx Workflow (more difficult) * Download all the tools/images from a host location * Then use the Tool Data.yxdb dataset to match tools to their visual assets Resources: * URL of zip file containing the images needed for Exercise 2 * Tool Data.yxdb challenge_97_start_file.yxzp challenge_97_solution.yxzp

I searched and I searched, but my instance of Alteryx install (2024.2 Non-Admin) doesn't have the Tool Icons folder (was going to paste the full path but Alteryx won't let me - boo!) Here's what I did instead... Spoiler After a long discussion with Chat GPT - I discovered all my tools are saved in one folder (I think) with their UUID as the file name (again, I think?). Supposedly, there's options to use APIs to make a list of UUIDs and tool names, etc. That was beyond me today, so I just created my own Tool Icons folder on my desktop with the images saved with their tool names. Fortunately, I had already mostly done this for another project. Still, this probably took me way too long. Per my usual. challenge097_submission_EM.yxzp

Spoiler challenge_97_start_file_DT.yxzp

Challenge #97: SANTALYTICS 2017 - Part 1

JoeM

It's building time in ‘alteryx-ese’

first we download data and p-n-gs!

Santa's orders are stacked too high!! How can we help keep the periodic table of Alteryx tools orders coming year after year? Automation in Alteryx, of course! First, we'll need image assets to create our unique periodic tables.

If you are just checking out #SANTALYTICS for the first time, please read our intro blog to see our team rap, learn about the badge, and maybe get a shot at some SWAG!

Goal:

Download image assets to make your periodic table visual from the web:

You can try two different paths:
- Download the .zip file and extract using an Alteryx Workflow (more difficult)
- Download all the tools/images from a host location

Then use the Tool Data.yxdb dataset to match tools to their visual assets

Resources:

URL of zip file containing the images needed for Exercise 2
Tool Data.yxdb

challenge_97_start_file.yxzp

challenge_97_solution.yxzp

Developer

Reporting

Join

Preparation

Advanced

Intermediate

Data Preparation

Accepted answers

All comments

patrick_digan

I went with option 1 and downloaded the zip from the web.

Spoiler

I used the download tool to get the zip file and then R to unzip the images.

I was able to add a few browse and change my connections to wireless to get a little more into the #Santalytics spirit:

challenge_97_start_file.yxzp

ggruccio

Love Santalytics! I used method 2 - downloading each file individually...

challenge_97_gg_finish.yxzp

LordNeilLord

I'm a method 2 kinda guy

Spoiler

challenge_97_LNL.yxzp

StephenRuhl

I went with option one.

Spoiler

I used jdunkerly79's unzip workflow (slightly modified) to unzip into a folder. I used REGEX to extract the file name from the full file path, then joined each asset from there.

2017 Santalytics.yxzp

Kenda

Spoiler

Method 2 for me!

Challenge 97.PNG

challenge_97_BarnesK.yxmd

Claje

Went down the option 1 route

Spoiler

It took me a little time to get the command line running as i expected - had to brush up on how to configure my paths how i wanted.

I also spent some time trying to join to each option that could have an image before deciding it would be faster to transpose->join->Cross Tab

challenge_97_start_file_Claje.yxzp

estherb47

Finally caught up with the challenges! I'm a Route #2 gal, so here's my solution. To avoid lots of joins, I went the transpose-join-crosstab route.

Spoiler

challenge_97_EHB_solution.yxzp

NicoleJohnson

Option #2 for me!

Spoiler

As if I needed any more reasons to love the Summarize tool... of course it has an option to combine images! It's a Christmas miracle!

challenge_97_NicoleJohnson.yxmd

samN

Option number two for me. Did this first with the image tool but realized it was a little cleaner with the blob tool! Back to catching up on past challenges

challenge_97.yxzp

Ilías

Method 2 it was!

Challenge 97 ili.yxmd

paul_houghton

So it took a bit of time working out the 7zip for method one but worth the effort i think

Spoiler

challenge_97.yxzp

MarqueeCrew

I like other solutions better than mine.... I also can't guess why Yellow is problematic. I thought that other folks might have asked about it.

Cheers,

Mark

challenge_97_Santalytics_MarqueeCrew.yxmd

jdunkerley79

Time to join in...

I chose option 1:

Spoiler

Didn't get the overlay working right but close...

challenge_97_jd.yxzp

Claje

@jdunkerley79

Spoiler

I think I'm going to have to look at your solution in depth just to see your powershell script! I didn't even think of leveraging powershell

LandonG

I used method 1--solution attached.

challenge_97_start_file.yxzp

LandonG

philipmannering

I used Method 2. My, aren't the reporting tools a tad fiddly. Starting to get the hang of them. Solution attached.

Spoiler

Output of workflow

challenge_97 - Santalytics Part 1.yxzp

SophiaF

Love me some alteryx-ese, especially when the Run Command tool is involved

Spoiler

challenge_97_start_file_completed.yxmd

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!

challenge_97_start_file.yxmd

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

WC97_LM.yxmd

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-workflow/m-p/10617#M1768

challenge_97_LP.yxzp

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 file

Then unzip it

Then load all of the images into a rowset

Then join them all together

Challenge_97_SeanSolution.yxzp

jasperlch

This is a tough one! Solution attached.

challenge_97_JL.yxzp

Natasha

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

challenge_97_Natasha.yxzp

Reinierk

challenge_97_Reinierk.yxmd

JosephSerpis

Challenge Completed

Challenge_97_Joe_Serpis.yxzp

Elena_Caric

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

challenge_97_start_file RESULT.yxmd

jamielaird

Here's how I solved it:

Spoiler

challenge_97_JL.yxzp

danilang

Good Challenge

Issues accessing Amazon from work, though. All links through Alteryx came back, forbidden. Worked from Chrome though. I had to download the images and retrieve them from disk. I tried to keep the work flow as similar as possible. About the only thing missing is the download tool.