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

euanwilson
8 - Asteroid
Spoiler
Initially a cross tab was used to put the name as the column header and the date of birth as the data entries within the column. To calculate the DOBs and the days of the week formula tools were used, mainly utilising DateTimeAdd to get the job done. 
Transpose was used to group the data under a name column and a date of birth one before a select tool was used to tidy the data up. 

Workflow.PNGResults.PNG
cplewis90
13 - Pulsar
13 - Pulsar

Fun challenge!

Spoiler
For the most part I solved this in a single formula tool and then the rest was just cleaning the data into the right frame to match the answer.
Neetu
8 - Asteroid

good mental exercise 🙂

Spoiler
solution_258.png
vikb03
8 - Asteroid

Long winded but got there in the end!

 

Spoiler
vikb03_0-1625499701055.png

 

carmenrapariz
8 - Asteroid
Spoiler
Challenge 258.PNG
beccat
8 - Asteroid

Looks like this is a common solution.   

 

Spoiler
beccat_0-1625761906296.png

 

amanda_payne
7 - Meteor
Spoiler
amanda_payne_0-1626295105795.png

 

Elias_Nordlinder
8 - Asteroid

Hmm, seems like other people liked the Cross Tab formula for this, I tried something else with the Multi-Row formula etc.

 

Spoiler
Elias_Nordlinder_0-1626430597880.png

 

KyronSmith
6 - Meteoroid

Favourite challenge so far!