Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
community Alteryx IO Mission Control
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
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 #198: Beverage Inventory

patrick_digan
17 - Castor
17 - Castor
‎01-13-2020 10:09 AM
Spoiler
Annotation 2020-01-13 130610.jpg
challenge_198_start_file.yxzp
Reply
0 Likes
T_Willins
14 - Magnetar
14 - Magnetar
‎01-13-2020 10:23 AM

My solution.

 

Spoiler
Workflow 198.png

 

challenge_198_solution.yxmd
Reply
0 Likes
hbraunius
8 - Asteroid
‎01-13-2020 11:43 AM

My solution attached.

challenge_198_solution_hb.yxzp
Reply
0 Likes
TonyA
Alteryx Alumni (Retired)
‎01-13-2020 11:46 AM

Here's my solution. There appears to be a discrepancy on some of the ETA dates. For example in Row 10 (Location 010, Product 370), the earliest date is actually June 29, not July 1.

challenge_198_TonyA.yxmd
Reply
JoseAlcorta
6 - Meteoroid
‎01-13-2020 12:30 PM

A little tricky but i think i got it right

Spoiler
198 resuelto.PNG
challenge_198_Jose.M.Alcorta.yxzp
Reply
abrouwer
8 - Asteroid
‎01-13-2020 12:44 PM
Spoiler
198 Spoiler.PNG

Solution Attached 

challenge_198_solution_file - AJB.yxmd
Reply
randreag
11 - Bolide
‎01-13-2020 01:29 PM

Here My solution!!

challenge_198_solved.yxmd
Reply
0 Likes
carlosteixeira
15 - Aurora
15 - Aurora
‎01-13-2020 01:54 PM

Hi guys, its my soultion!!!

 

Spoiler
carlosteixeira2005_0-1578952276381.png
Carlos A Teixeira
challenge_198_solution_CT.yxmd
Reply
0 Likes
JustinBabbitt
Alteryx
Alteryx
‎01-13-2020 02:07 PM

Its fun to see how others solve data issues...

Spoiler
JustinBabbittEAG_0-1578953133610.pngI chose to create a lookup for the missing Location Names so it can be dynamic for the next run. But, next time the missing value could be that of a beer... Cool challenge! 
Justin Babbitt
challenge_198_End_file_JTBEAG.yxmd
Reply
terry10
12 - Quasar
‎01-13-2020 02:33 PM

 

A good reminder that unjoined records don't get reformatted according to the embedded select settings. In retrospect, I wish I had used the Multiple Join tool rather than chasing down the unjoined records.

 

Spoiler
challenge 198 ss.PNG

 

Reply