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!

sknman92
Astéroïde

my solution

Rob-Silk
Astéroïde

Standard solution:

Révélation
challenge_365a_RS_screencap.PNG

 

App-based solution:

Révélation
challenge_365b_RS_screencap.PNGchallenge_365c_RS_screencap.PNGchallenge_365d_RS_screencap.PNG
snbandi
Astéroïde

My solution for Simple version. Intermediate to come later for after more experience with other tools.

asultanov
Astéroïde

Solution & app attached.

becky-pattinson
Météore
Révélation
Challenge 365 BP.png
Mikeimbi
Astéroïde

With App

Lucy_Hickman
Météoroïde

The challenge_365_solution app does not contain an error message for "Sorry, the ID number you entered does not exist." 

 

I would have liked to have seen how you include an error message when a user enters an ID that doesn't match to an ID in the column ID. I've only seen error message displayed when the input doesn't match a certain format. 

Lucy_Hickman
Météoroïde

The best Error Message Expression I could come up with is 

 

REGEX_Match([#1], '^(?!\d{4,5}$).*$')

 

this will only be true when its not a 4 or 5 digit number. This will still allow invalid 4 or 5 digit IDs to pass through the workflow and the user will only realize once they open an empty PDF. 

mwong
Astéroïde

what a challenge.  my solution:

toby49
Astéroïde

My solution:

 

Révélation
Screenshot 2024-04-10 093300.pngScreenshot 2024-04-10 092333.pngScreenshot 2024-04-10 093158.png