Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

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
Spoiler
Annotation 2020-01-13 130610.jpg
T_Willins
14 - Magnetar
14 - Magnetar

My solution.

 

Spoiler
Workflow 198.png

 

hbraunius
8 - Asteroid

My solution attached.

TonyA
Alteryx Alumni (Retired)

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.

JoseAlcorta
6 - Meteoroid

A little tricky but i think i got it right

Spoiler
198 resuelto.PNG
abrouwer
8 - Asteroid
Spoiler
198 Spoiler.PNG

Solution Attached 

randreag
11 - Bolide

Here My solution!!

carlosteixeira
15 - Aurora
15 - Aurora

Hi guys, its my soultion!!!

 

Spoiler
carlosteixeira2005_0-1578952276381.png
Carlos A Teixeira
JustinBabbitt
Alteryx
Alteryx

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
terry10
11 - Bolide

 

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