topic Re: Challenge #253: Delivery Dates in Weekly Challenges

Challenge #253: Delivery Dates

AYXAcademy — Tue, 13 Sep 2022 14:40:35 GMT

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

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.

Re: Challenge #253: Delivery Dates

Aaron_Harter — Mon, 01 Feb 2021 14:42:03 GMT

I love a two tool solution!

Re: Challenge #253: Delivery Dates

DeanWest — Mon, 01 Feb 2021 14:40:50 GMT

Nice and easy challenge to start the week!

Re: Challenge #253: Delivery Dates

Blake — Mon, 01 Feb 2021 14:57:33 GMT

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

Re: Challenge #253: Delivery Dates

RolandSchubert — Mon, 01 Feb 2021 15:05:04 GMT

Re: Challenge #253: Delivery Dates

AkimasaKajitani — Mon, 01 Feb 2021 15:08:11 GMT

My solution.

Re: Challenge #253: Delivery Dates

Kenda — Mon, 01 Feb 2021 15:11:34 GMT

Re: Challenge #253: Delivery Dates

Sashikumar — Mon, 01 Feb 2021 15:15:49 GMT

Good one.

Re: Challenge #253: Delivery Dates

Spalders — Mon, 01 Feb 2021 15:39:01 GMT

Re: Challenge #253: Delivery Dates

Tony_Castillo — Mon, 01 Feb 2021 15:55:21 GMT

Re: Challenge #253: Delivery Dates

balajilolla — Mon, 01 Feb 2021 17:13:43 GMT

Solution Attached

Re: Challenge #253: Delivery Dates

OllieClarke — Mon, 01 Feb 2021 17:32:33 GMT

Here's my solution:

Re: Challenge #253: Delivery Dates

lewis-chambers — Mon, 01 Feb 2021 17:43:41 GMT

Here's my solution

I do love splitting out the formula tools (force of habit) but appreciate any feedback to shorten and speed up the workflow.

Re: Challenge #253: Delivery Dates

phottovy — Mon, 01 Feb 2021 17:52:06 GMT

Pretty straightforward:

Re: Challenge #253: Delivery Dates

LHolmes — Mon, 01 Feb 2021 17:59:05 GMT

Nice quick core challenge to start the week. Always enjoy reviewing and tinkering with Date Specifiers.

If you haven't discovered it, here is a great resource on functions: https://help.alteryx.com/2019.4/Reference/Functions.htm

You can get to is quickly in designer by typing Functions into the search and looking for the result under the help category, OR clicking on the ? in the Formula tool configuration and then clicking the Functions link in the first paragraph.

Re: Challenge #253: Delivery Dates

FlorianC — Mon, 01 Feb 2021 18:17:12 GMT

If only we could automate the actual delivery; no more delays!

Workflow

Re: Challenge #253: Delivery Dates

ggruccio — Mon, 01 Feb 2021 18:23:15 GMT

Fairly concise!

Re: Challenge #253: Delivery Dates

jferrone — Mon, 01 Feb 2021 18:52:17 GMT

My answer is attached. Thank you providing the weekly challenge.

Re: Challenge #253: Delivery Dates

ponraj — Mon, 01 Feb 2021 18:58:12 GMT

Here is my solution

Re: Challenge #253: Delivery Dates

dsmdavid — Mon, 01 Feb 2021 20:38:19 GMT

According to this, people were delivering orders on Jan 1st... should be criminal