We’ve extended Inspire Early Bird Pricing until March 1. Register now and enjoy 20% off conference passes and 10% off training passes. P.S. Don’t forget to bring friends! When you sign up for five or more tickets, you get an extra 20% discount on conference passes. Learn more now.

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

AYXAcademy
Alteryx
Alteryx

A solution to last week's challenge can be found here

 

This week's challenge comes to us from @bdelarosa - thank you for your contribution! 

 

Using the provided input files, organize the data to display:

 

- Inventory levels for products by location
- Previous sales history per product per location
- Average sales per product per location
- Total incoming product per product per location
- Earliest Purchase Order date a product may arrive.

 

Display all inventory levels even if no sales exist or no products are on purchase order.

 

beer_gif.gif

Source: GIPHY

Aaron_Harter
11 - Bolide

This challenge is making me thirsty!

Spoiler
wc 198.PNG
OllieClarke
15 - Aurora
15 - Aurora

Here's my effort:

Spoiler
Challenge 198.png
JoshuaGostick
11 - Bolide

There was some frustration trying to identify which table some of the fields were coming from but other than that a good fun challenge!

 

Spoiler
challenge_198.PNG

 

Blake
12 - Quasar

Shout out to the RGV locations in this challenge! 

 

 

Spoiler
WC198fin.png

 

NicoleJohnson
ACE Emeritus
ACE Emeritus

My solution!

 

Spoiler
WeeklyChallenge198.JPG

Cheers!!

NJ

nivi_s
8 - Asteroid

Solved!

Now I just gotta get some pop-tarts to go with these beers!

Spoiler
Might be a more elegant way to do this - the unmatched fields were a bit of a pain, but I think I worked it out in the end! 
nivi_s_0-1578935157562.png
ponraj
13 - Pulsar

Here is my solution. 

 

Spoiler
Capture.PNG
RolandSchubert
16 - Nebula
16 - Nebula

My solution. Cheers.

 

Spoiler
13-01-_2020_18-58-22.png
JORGE4900
8 - Asteroid

I found the most time-consuming thing was to add default missing values in a manual way such as Location, Inventory Qty, Units Sold, or dates; other than that, it was pretty straight forward doing a couple of joins to get solution.

 

Happy Monday!

 

Spoiler
2020-01-13_10-49-03.jpg