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

Accidentally hit submit...see below...

Highlighted
Bolide
Bolide

I agree with @TonyA about the min dates. I think if sorting a string, July 1, 2019 comes before June 29, 2019 however in date-time format it is the opposite.

 

Otherwise great challenge!

Highlighted
Asteroid

Hi! Here my solution

 

Spoiler
challenge 198.PNG
Highlighted
Fireball

@TonyA  and @ggruccio Great points!  The start file has been updated to reflect both solutions: the original solution, and the solution with DateTimes used to find the earliest values. 

Highlighted
Alteryx Partner

 

Solution attached. Thanks

 

Spoiler
bstroh_0-1578960767411.png
Highlighted
Asteroid

My Solution: 

Highlighted
Alteryx Partner
Spoiler
キャプチャ.JPG
Highlighted
Meteor

Cool thanks, although it was quite an ez challenge I purposely embedded small land mines

Highlighted
Meteor

Yea thanks it was my challenge, I know it was easy but I thought it was a good practice for beginners. The data was real, I just changed the name of beers, but I used to do all this work daily via vlookups on excel Every **bleep** day it would literally take me 2 hours every morning to put it together until of course the discovery of Alteryx the best software ever automated it for me!!! 🤪

Highlighted
Magnetar
Magnetar

My solution. Where are the pop tarts???

 

Spoiler
EstherB47_0-1578978914962.png

Cheers!

Esther