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 #19: Excel Record Locator

michalsicak
7 - Meteor

I'm quite sure this must be possible to solve in a simpler manner, but still.

 

Spoiler
challenge19.png
derekbelyea
12 - Quasar
Spoiler
CH19.png
MaxGiegerich
8 - Asteroid

One branch needs added per new cell queried, so ok if there's only 2 cells but might not scale as nicely as the sample answer!

MaxGiegerich
8 - Asteroid

One branch needs added per new cell queried, so ok if there's only 2 cells but might not scale as nicely as the sample answer!

TeePee
8 - Asteroid

My solution.

ddiesel
13 - Pulsar
13 - Pulsar

Without peeking, my solution was sloppy by comparison. I enjoyed reading everyone's solutions. Thanks!

 

 

JosephSerpis
17 - Castor
17 - Castor

Challenge Completed

kcgreen
8 - Asteroid

This challenge taught me that I've been overusing the dynamic input tool in my workflows.  Dang....all the wasted time making source templates I didn't need to make.  

 

Here's my solution:

 

Spoiler

 

Challenge19.JPG

 

 

wanjum
Alteryx Alumni (Retired)

Solution Attached.

asabau
8 - Asteroid

Here it is!