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 #258: Relatively Old

Toons
12 - Quasar

My solution (with DateTimeFormat, DateTimeAdd and DateTimeTrim) :

 

Spoiler
Toons_0-1615218136901.png

 

LHolmes
9 - Comet

Always like digging into date functions.

 

Spoiler
258 - Solution.PNG
ggruccio
13 - Pulsar
13 - Pulsar

Got the output - just in a different order by name.  (The order that I solved each)

 

ggruccio_0-1615218928857.png

 

Spoiler
I wanted to make sure I wasn't missing leap years so didn't convert any of the units to days (i.e. years x365)....It all came out correctly.  For the first day of the month I extracted the components of Stephane's date and changed the day to "01" then re-assembled as a date.  For Juliette I added a week worth of dates to Stephane then after adding Day of the Week pulled the one that matched Friday.
ggruccio_1-1615219119866.png

 



 

binuacs
8 - Asteroid
Spoiler
binuacs_0-1615219529500.png

 

MPard
6 - Meteoroid
Spoiler
MPard_0-1615220420539.png

 

Fun little challenge. Interesting case to use the Cross tab and transpose in one flow.

RolandSchubert
15 - Aurora
15 - Aurora
Spoiler
258.jpg
Tyro_abc
11 - Bolide

Tyro_abc_0-1615223118580.png

Best Regards

Arundhuti

apathetichell
15 - Aurora

I was hoping I could automate this more - but it ended up being fairly individualized by record.

jferrone
8 - Asteroid

Happy Monday! I took two approaches and both came to same answer. 

 

Spoiler
jferrone_0-1615224823122.png
jferrone_1-1615224866603.png

 

 

 

OllieClarke
13 - Pulsar
13 - Pulsar

Here's my solution 🙂

Spoiler
OllieClarke_0-1615225270187.png