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
ボリード
スポイラ
ahsanaali_0-1680533614388.png
スポイラ
ahsanaali_0-1680579155825.png

 

bobd
アステロイド

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

Kenda
16 - Nebula
16 - Nebula
スポイラ
Kenda_0-1680533963754.png

 

mmontgomery
ボリード

A good use case for an app!

スポイラ
mmontgomery_0-1680534480320.pngmmontgomery_1-1680534499704.png

 

 

ggruccio
ACE Emeritus
ACE Emeritus

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

 

スポイラ
ggruccio_0-1680537076122.png

 

Luke_C
キャスター
スポイラ
Luke_C_0-1680537139568.png

 

jialiangzhen
アトム

Posted

messi007
15 - Aurora
15 - Aurora

Below my solution :

 

スポイラ
messi007_0-1680538510263.png

 

gerda
アステロイド
スポイラ
gerda_0-1680538569913.png

 

Here's the solution!