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 currently experiencing an issue with Email verification at this time and working towards a solution. Should you encounter this issue, please click on the "Send Verification Button" a second time and the request should go through. If the issue still persists for you, please email support@alteryx.com for assistance.

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
16 - Nebula

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