Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! 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 #253: Delivery Dates

balajilolla
8 - Asteroid
Spoiler
Solution Attached

balajilolla_0-1612199608764.png

 

OllieClarke
15 - Aurora
15 - Aurora

Here's my solution:

Spoiler
Challenge 253.PNG
lewis-chambers
5 - Atom

Here's my solution

Spoiler
lewis-chambers_0-1612201335352.png

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

phottovy
13 - Pulsar
13 - Pulsar

Pretty straightforward:

Spoiler
253.PNG
LHolmes
9 - Comet

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

 

Spoiler
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.
253 - Solution.PNG
FlorianC
Alteryx
Alteryx

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

 

Spoiler
WorkflowWorkflow
Florian Carrier
Strategic Solution Consultant
Alteryx
ggruccio
ACE Emeritus
ACE Emeritus

Fairly concise!

 

Spoiler
ggruccio_0-1612203781692.png

 

jferrone
8 - Asteroid
Spoiler
jferrone_1-1612205420991.png

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

ponraj
13 - Pulsar

Here is my solution

 

Spoiler
Workflow.PNG
dsmdavid
11 - Bolide

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

Spoiler
dsmdavid_0-1612211831950.png