Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

Weekly Challenges

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

SUBMIT YOUR IDEA

Challenge #250: Give Me A Sign

AYXAcademy
Alteryx
Alteryx

A solution to last week's challenge can be found heremarquee_box.jpg

 

This week's challenge was submitted by @kelly_gilbert   - Thank you for your submission!

 

I bought a lighted marquee box to decorate my office, and I have had a lot of fun updating the message. However, it takes a long time to sort through the letter tiles to see if I have enough for the message I have in mind.

 

For this challenge, please build an app that will make sure that I have enough of each letter for my desired message. Note, some tiles can be used for multiple characters (e.g. 6 and 9, O and zero).

 

You don't need to check the message for fit (although, if you want an extra challenge, my marquee box can hold three rows of eight tiles).

Aaron_Harter
11 - Bolide

250 in the books!

Spoiler
0.PNG

1.PNG
Blake
12 - Quasar

❤️ Alteryx!

 

Interface: 

 

Spoiler
interface(1).png

 

 

 

Workflow: 

Spoiler
250.png

Message Examples:

 

Spoiler
Valid MessageValid MessageInvalid MessageInvalid Message 

 

 

 

dsmdavid
11 - Bolide
Spoiler
dsmdavid_0-1610379554663.png
dsmdavid_1-1610379599834.png

 

 

AkimasaKajitani
17 - Castor
17 - Castor

My solution.

 

Spoiler
AkimasaKajitani_0-1610380625248.png

AkimasaKajitani_1-1610380651552.png
clop4.png
 

 

 

For debug :

Spoiler
 

Test word : I [heart] Alteryx 666 999 AAAA!!!!

 

clip1.png
clip2.png

 

ponraj
13 - Pulsar

Here is my solution!

 

Spoiler
5.PNG4.PNG3.PNG2.PNG1.PNGWorkflow.PNG
ggruccio
ACE Emeritus
ACE Emeritus

A morning well spent!  250!!!

 

Spoiler
I found that rendering to a temporary .pdf works in communicating the result, but really wanted it to be part of the app popup at the end. - Update!  Figured it out!  It is to show the results of the Browse in the Interface Designer!  Re-posted results and workflow.
ggruccio_1-1610381369421.pngggruccio_1-1610381869636.png

 

 


ggruccio_0-1610381837820.png

 


 

phottovy
13 - Pulsar
13 - Pulsar

Another challenge complete:

Spoiler
250.PNG


250a.PNG250b.PNG

 

atcodedog05
22 - Nova
22 - Nova

A Fun 250 challenge 🎉

 

Spoiler
atcodedog05_0-1610391082853.png

 

Spoiler
atcodedog05_1-1610391119762.pngatcodedog05_2-1610391150066.png

 

Cheers and Happy Analyzing 😀 

patrick_digan
17 - Castor
17 - Castor

I wonder if @MarqueeCrew is game for a marquee challenge.

Spoiler
I had fun replacing the symbols with their actual unicode characters. 
patrick_digan_0-1610394932010.png