Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!
New content is available in Academy! You may need to clear your browser cache for an optimal viewing experience

Challenge #198: Beverage Inventory

Highlighted
Spoiler
Annotation 2020-01-13 130610.jpg
Highlighted
Quasar

My solution.

 

Spoiler
Workflow 198.png

 

Highlighted
Asteroid

My solution attached.

Highlighted
Alteryx
Alteryx

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.

Highlighted
Meteoroid

A little tricky but i think i got it right

Spoiler
198 resuelto.PNG
Highlighted
Meteor
Spoiler
198 Spoiler.PNG

Solution Attached 

Highlighted
Alteryx Partner

Here My solution!!

Highlighted
Alteryx Certified Partner

Hi guys, its my soultion!!!

 

Spoiler
carlosteixeira2005_0-1578952276381.png
Highlighted
Alteryx Certified Partner

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! 
Highlighted
Asteroid

 

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