Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!

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 #115: Let's get crafty!

AmandaH
8 - Asteroid

Here's my solution! I arrived at the solution very differently that the provided solution, but my list of Craft Beer styles was manually entered in mine, not dynamic. 

 

 

Spoiler
What I Learned: The DropDown interface tool can be populated from a connected tool by cross tabbing your list and making each item on your list, a column. 

AmandaH_1-1601049146091.png
AmandaH_0-1601049115481.png

 

ClintonF
Alteryx
Alteryx
Spoiler
Spoiler
challenge_115_CF.JPG
Clinton Fisher
Manager, Customer Success Management
Alteryx, Inc.

AkimasaKajitani
17 - Castor
17 - Castor

My solution.

Spoiler
AkimasaKajitani_0-1601308010818.png

 

Billigans
8 - Asteroid
Spoiler
Billigans_0-1601576372252.png

 

Sntrada
11 - Bolide

Took me a while because I am pretty new to this and I had to consult the solution. But here's mine! 🙂

liamholland
8 - Asteroid

Solution (bit overcomplicated but works):

Spoiler
Solution.png
joshuaburkhow
ACE Emeritus
ACE Emeritus

A good challenge

Joshua Burkhow - Alteryx Ace | Global Alteryx Architect @PwC | Blogger @ AlterTricks
KilianL
Alteryx Alumni (Retired)

I tried two different approaches to generate only the selected output.

 

Spoiler
Detour Tool and Filter Tool using 'OR'

DetourDetourFilter using ORFilter using OR

Ross_Easton
8 - Asteroid

Solved

 

Spoiler
115.PNG

JP_SDAK
8 - Asteroid

As a beer lover and needing to practice applications, this was the perfect challenge!

Spoiler
JP_SDAK_0-1605330619520.pngJP_SDAK_1-1605330643747.png