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 #191: BINGO!

Highlighted
5 - Atom

First off, this is my very first Alteryx Challenge completion! I've used the tool in varying capacity for about a year, but I'm really interested in progressing and becoming more efficient. That being said, I completed this for Beginner. My screenshot and workflow are attached.

 

 

Spoiler
One pitfall I know I fell into was that my technique means that the same item can appear more than once on each card. I'm eager for suggestions, tips on avoiding this! Thanks so much!

Capture2.PNGCapture.PNG

 

 

 

 

 

Highlighted
6 - Meteoroid

A completed intermediate version of this challenge! Still not familiar enough with the Reporting tab to tackle the Advanced version. 

Highlighted
7 - Meteor
 
Highlighted
8 - Asteroid

Got there in the end - snuck a peak at Sean Adams solution to get the final format right for the advanced answer.

 

Spoiler
Flow

JamesCameron_0-1575156827035.png


Macro

JamesCameron_1-1575156889197.png
Highlighted
14 - Magnetar
14 - Magnetar
Spoiler
My quick beginner solution so I don't get too far behind on these again!

Capture.PNG

Highlighted
Alteryx Partner

Seems I forgot to post this on Wednesday when I finished up. I wasn't quite able to figure out the image text overlay, but the remainder is pretty close. I went a little overboard "guaranteeing" that there weren't any duplicates, but I probably just made it a little harder for myself.

 

Workflow:

 

Spoiler
Workflow.png

Batch Macro:

 

 

Spoiler
Batch Macro.png

 

Iterative Macro:

 

Spoiler
Iterative Macro.png

 

Highlighted
Alteryx
Alteryx

 

A fun weekly challenge - found I was able to simplify my steps with a few report tool tricks:

  • Make Columns - such a fun and under utilized function
  • Passing style tags to vertically center contents in the bingo tiles
  • Using RegEx tool with the <htmlpassthrough> tag to find replace the free space with a base64 encoded image. 
Spoiler
weekly_challenge_191.jpg

 

Highlighted
7 - Meteor

Thanks for posting this!

 

I really had no idea how to approach this one (okay, well, some idea but not enough knowledge to actually do it) - so I set about trying to find an example that I could reverse-engineer so that I could learn how to do this. Your spoiler seemed to fit the bill so I downloaded your solution and it's great 🙂

Highlighted
8 - Asteroid

🙂

Highlighted
Alteryx
Alteryx

Stuck somewhere between beginner and intermediate.  Got a basic table output full of random options for 1 card.  Just peeked at the solution and I want to take it all the way.

 

Spoiler
RobertW_0-1576089840885.png