The Alteryx Community is a finalist in three 2026 CMX Awards! Help us win Customer Support Community, Most Engaged Community, and User Group Program of the Year - vote now! (it only takes about 2 minutes) before January 9.
ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests Early 2026. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions.
Learn more 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
No problems.
Spoiler
I first converted the date of birth field from the Driver Profiles input into a date format.
I then joined the Race Details and the Race Results inputs, then created a grouped sum showing the total points for each driver per year. I then took the highest points for each year using a Sample tool as we're only interested in those with the highest points. This gave me the winner for every season. I then joined this to the Driver Profiles.
Using the converted Date of Birth field I calculated the age by simply subtracting the year from the DoB from the season year to arrive at an age in years. I then sorted it to give me the highest age for each year, and sampled the first and last records to get the oldest and youngest. Then I joined the constructor ID and boom.
I first converted the date of birth field from the Driver Profiles input into a date format.I then joined the Race Details and the Race Results inputs, then created a grouped sum showing the total points for each driver per year. I then took the highest points for each year using a Sample tool as we're only interested in those with the highest points. This gave me the winner for every season. I then joined this to the Driver Profiles.
Using the converted Date of Birth field I calculated the age by simply subtracting the year from the DoB from the season year to arrive at an age in years. I then sorted it to give me the highest age for each year, and sampled the first and last records to get the oldest and youngest. Then I joined the constructor ID and boom.
Onto the next one.
M.
