We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.
We are updating the requirements for Community registration. As of 7/21/21 all users will be required to register a phone number with their My Alteryx accounts. If you have already registered, you will be prompted on your next login to add your phone number.

Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback

Challenge #253: Delivery Dates

AYXAcademy
Alteryx
Alteryx

A solution to last week's challenge can be found hereDelivery Truck.png

 

A furniture store located in New York schedules their deliveries for customers based on the transit time to the order’s specified location. The first dataset contains a list of customers, the date of their order, and the state they live in. The second dataset is a list of transit times from the furniture store. This store does not deliver on weekends, so orders that arrive on the weekend will need to be delivered on the following business day.

 

Create a workflow to assign each order an appropriate delivery day and incorporate the date into a message describing when the order will be delivered.

Aaron_Harter
11 - Bolide

I love a two tool solution!

Spoiler
1.PNG
DeanWest
9 - Comet

Nice and easy challenge to start the week!

 

Spoiler
challenge_253_solution_DeanWest-snippet.png

 

Blake
12 - Quasar

Used the Find&Replace for efficiency rather than a Join.

 

Spoiler
wc253bh.png

 

 

RolandSchubert
15 - Aurora
15 - Aurora
Spoiler
253.png
AkimasaKajitani
14 - Magnetar

My solution.

 

Spoiler
AkimasaKajitani_0-1612192068073.png

 

Kenda
15 - Aurora
15 - Aurora
Spoiler
Kenda_0-1612192278125.png

 

Sashikumar
8 - Asteroid

Good one.

Spoiler
ch253.PNG
Spalders
8 - Asteroid
Spoiler
Spalders_0-1612193893522.png

 

TC_bot
8 - Asteroid
Spoiler
TC_bot_0-1612194903975.png