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

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 #365: LEGO® My Data!

alexnajm
17 - Castor
17 - Castor

Lego my eggo?

Spoiler
Challenge 365.PNG
alacoume
9 - Comet

My solution:

westlakecjw
8 - Asteroid

Used beginner challenge as basis for developing the app. Good challenge this week!

Spoiler
westlakecjw_0-1680616668764.png

 

Sebastian_Chaieb2
9 - Comet
9 - Comet

I Love LEGO bricks 😍

 

I used filter with CONTAINS statement to filter the LEGO sets if you do not remember full set ID

 

Sebastian_Chaieb2_0-1680619156484.png

 

Spoiler
Sebastian_Chaieb2_1-1680619176376.png

 

 

Also I am attaching a solution with Drop down list where you can select a Lego set from existing lookup file

 

Spoiler
Sebastian_Chaieb2_0-1680619467250.png

 

annbriceAB
8 - Asteroid

Here is the Beginner Challenge.

ARussell34
8 - Asteroid

Quick app!

 

ARussell34_0-1680620303632.png

 

dmccarville
7 - Meteor

 

 

 

Spoiler
dmccarville_0-1680621485658.png

 

balajilolla2
9 - Comet
Spoiler
Solution Attached

balajilolla2_0-1680641800631.png

 

AaronSmatta
8 - Asteroid

Solution for Intermediate

TonyAndriani
9 - Comet

Got through most of the bonus challenge. By the way, for my example I used 7191, which was the first large (for the time) Lego kit I ever built. Still have it on my shelf... 

Spoiler
Couldn't figure out a way to block the generation of a PDF if there was no data, so I could never get to the No Output files message. So I throw and error if there are no rows, abort the workflow and include a message in the error window. Really interested in seeing how to block output more cleanly.
TonyAndriani_0-1680666425505.png

 

TonyAndriani_1-1680666469722.png