Challenge #97: SANTALYTICS 2017 - Part 1
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I went with option 1 and downloaded the zip from the web.
I was able to add a few browse and change my connections to wireless to get a little more into the #Santalytics spirit:
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I went with option one.
Stephen Ruhl
Principal Customer Support Engineer
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Went down the option 1 route
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Option #2 for me!
NJ
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator