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 #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
16 - Nebula
16 - Nebula
Spoiler
253.png
AkimasaKajitani
17 - Castor
17 - Castor

My solution.

 

Spoiler
AkimasaKajitani_0-1612192068073.png

 

Kenda
16 - Nebula
16 - Nebula
Spoiler
Kenda_0-1612192278125.png

 

Sashikumar
8 - Asteroid

Good one.

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

 

Tony_Castillo
9 - Comet
Spoiler
TC_bot_0-1612194903975.png