Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!
IDEAS WANTED

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback
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.

Challenge #64: Catch Me If You Can

Highlighted
14 - Magnetar
14 - Magnetar

Fun one!! Needed only a few tools to accomplish, and I left the county names in. Dynamic tools are wonderful

Spoiler
Spoiler
image.png
Highlighted
Alteryx Certified Partner

And another...

 

Spoiler
I began by creating the titles from the "Fields" input, which is a combination of the Category, Subcategory and Description, I then used Dynamic Rename to take the new column from the Fields input and replace the Name column from the data. I then used Dynamic Select to to remove the non-title fields.

Solution.PNGResults.PNG
Highlighted
Alteryx Certified Partner

Great use case for the Dynamic tools!

 

Spoiler
Weekly Challenge 64.png
Highlighted
Alteryx Certified Partner

Here's my solution.  Not sure why the posted solution doesn't include a location field (seems important!) so I've kept that in.

 

Spoiler
challenge-64.PNG

 

Highlighted
Alteryx Certified Partner

Solution Attached!  Had never used dynamic select before.

Highlighted
10 - Fireball
Spoiler
Created a long workflow only to realize that crosstab alphabetizes columns and then realized that a dynamic rename and select make it pretty simple.

Another one down

Highlighted
12 - Quasar
12 - Quasar

Another use case for transpose and crosstab

Highlighted
8 - Asteroid

Solution attached.

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

Definitely not the best. Looks like everyone nailed it with a dynamic select. Solution attached.

 

Spoiler
challenge_64 - Snip.PNG
Highlighted
12 - Quasar

Solution attached.