Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
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.
