Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. 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

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
12 - Quasar
 
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!