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.
2022.1.1.30569 Patch Release Update

The 2022.1.1.30569 Patch/Minor release has been removed from the Download Portal due to a missing signature in some of the included files. This causes the files to not be recognized as valid files provided by Alteryx and might trigger warning messages by some 3rd party programs. If you installed the 2022.1.1.30569 release, we recommend that you reinstall the patch.

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 #29: Alteryx '16 Grand Prix (Race1, L1)

dmodest
7 - Meteor

My version of the solution. As others have noted, the 2015 Team Rank is no longer included in the original files.

 

Spoiler
My solution includes the Dynamic Rename tool.
Capture.PNG
dmodest
7 - Meteor

Hello @ponraj ,

Can you tell us why you added two Dynamic Rename tools? I'm trying to understand how it is being used based on your spoiler pic. Sorry, my laptop is being repaired and I don't have access to open the workflow right now.

hayley9
8 - Asteroid

Here is my solution.

paulburrows
8 - Asteroid

Thanks guys

Pang_Hee_Choy
10 - Fireball
 
mpennington
11 - Bolide

Solution attached.  One of the players was listed twice in the desired output, despite there only being 252 in the fantasy list.  There was also no data on 2015 rank, excluding in the desired output. 

 

Spoiler
MP29.png
SamDesk
11 - Bolide
Spoiler
Annotation 2020-03-17 161309.png

There is a duplicate join for player "MATT DUFFY" in this (and the official) solution

 

Sam 🙂

 

ponraj
13 - Pulsar

Hi @dmodest , First one is to make first row values as column header.  I used same tool second time to rename some column header using formula. 

myouree
8 - Asteroid

Solution attached.

jaschirmer
7 - Meteor

Solution attached, thanks!