Join the Alteryx Community’s Maveryx Summer Cup event! Compete, network with others, and earn your gold through a series of challenges from July 24th to August 11th. Learn more about the event 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 #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
ACE Emeritus
ACE Emeritus

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
20 - Arcturus
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
16 - Nebula
16 - Nebula
Spoiler
258.jpg
Tyro_abc
11 - Bolide

Tyro_abc_0-1615223118580.png

Best Regards

Arundhuti

apathetichell
19 - Altair

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
15 - Aurora
15 - Aurora

Here's my solution 🙂

Spoiler
OllieClarke_0-1615225270187.png