ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests Early 2026. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions. Learn more here
Start 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
19 - Altair
19 - Altair

Lego my eggo?

スポイラ
Challenge 365.PNG
alacoume
コメット

My solution:

westlakecjw
アステロイド

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

スポイラ
westlakecjw_0-1680616668764.png

 

Sebastian_Chaieb2
11 - Bolide
11 - Bolide

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

 

スポイラ
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

 

スポイラ
Sebastian_Chaieb2_0-1680619467250.png

 

annbriceAB
アステロイド

Here is the Beginner Challenge.

ARussell34
アステロイド

Quick app!

 

ARussell34_0-1680620303632.png

 

dmccarville
メテオール

 

 

 

スポイラ
dmccarville_0-1680621485658.png

 

balajilolla2
ファイアボール
スポイラ
Solution Attached

balajilolla2_0-1680641800631.png

 

AaronSmatta
アステロイド

Solution for Intermediate

TonyAndriani
コメット

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... 

スポイラ
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