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

AYXAcademy
Alteryx
Alteryx

A solution to last week’s challenge can be found here. LEGO_logo.png

 

To solve this week’s challenge, use Designer Desktop, Designer Cloud Trifacta Classic and Designer Cloud Designer Experience.  

We provided both a beginner and intermediate version of the challenge. It is up to you which one to solve! 

A friend recently gifted you a LEGO® model kit; however, it did not come with the original packaging. You received the bricks and an ID number. Use the datasets provided to determine which LEGO model you are building.  

Beginner Challenge: 

Given the ID number 11148, determine which LEGO model you are building, the year it was released, the number of parts, and the LEGO collection it belongs to. 

Intermediate Challenge (Desktop):  

Create an app that allows users to enter an ID number to determine which LEGO model they are building, the year it was released, the number of parts, and the LEGO collection it belongs to. The results should be displayed in a table and output to a PDF file (as shown in the image below). 

App_Images.png

 

 

 

 

 

 

 

 

 

 

 

Data Source: https://www.kaggle.com/datasets/rtatman/lego-database?resource=download

 

ahsanaali
11 - Bolide
Spoiler
ahsanaali_0-1680533614388.png
Spoiler
ahsanaali_0-1680579155825.png

 

bobd
8 - Asteroid

I did the beginner challenge using alteryx cloud (trifacta classic). 

Kenda
16 - Nebula
16 - Nebula
Spoiler
Kenda_0-1680533963754.png

 

mmontgomery
11 - Bolide
11 - Bolide

A good use case for an app!

Spoiler
mmontgomery_0-1680534480320.pngmmontgomery_1-1680534499704.png

 

 

ggruccio
ACE Emeritus
ACE Emeritus

Fairly simple App Interface - used beginner solution as a template.

 

Spoiler
ggruccio_0-1680537076122.png

 

Luke_C
17 - Castor
17 - Castor
Spoiler
Luke_C_0-1680537139568.png

 

jialiangzhen
6 - Meteoroid

Posted

messi007
15 - Aurora
15 - Aurora

Below my solution :

 

Spoiler
messi007_0-1680538510263.png

 

gerda
8 - Asteroid
Spoiler
gerda_0-1680538569913.png

 

Here's the solution!