ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests Early 2026. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions. Learn more here
community Alteryx IO MyAlteryx
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
Start Free Trial

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

cplewis90
13 - Pulsar
13 - Pulsar
‎02-22-2019 10:51 AM

Fun challenge! Curious to see how others solved this one!

Spoiler
Challenge 19.PNG
challenge_19_CL.yxmd
Reply
0 Likes
Moni
6 - Meteoroid
‎02-27-2019 11:08 AM
my solution
challenge_19_M.yxmd
Reply
0 Likes
nikolaskardasis
8 - Asteroid
‎03-03-2019 02:23 PM
Spoiler
Capture.PNG
challenge_19_solution.yxmd
Reply
0 Likes
IgnasP
6 - Meteoroid
‎03-05-2019 05:53 AM
 
Reply
0 Likes
IJReed
8 - Asteroid
‎03-06-2019 10:09 AM
Spoiler
spoiler.PNG

👍

challenge_19_start_file.yxmd
Reply
0 Likes
Benbryans
8 - Asteroid
‎03-08-2019 01:10 AM

This one thoroughly confused me but got there in the end with some help!

 

Just did the multi-row formula a bit different to the provided solution.

Challenge_19_Solution.yxmd
Reply
joshuaburkhow
ACE Emeritus
ACE Emeritus
‎03-10-2019 06:57 AM

There are many good applications for this one!

Joshua Burkhow - Alteryx Ace | Global Alteryx Architect @PwC | Blogger @ AlterTricks
challenge_19_jb.yxmd
Reply
0 Likes
dpcurtis
7 - Meteor
‎03-12-2019 07:43 AM

I did it hard the first time, you are allowed to laugh.

Then I thought about it and ended up with the actual solution.

 

Yea Dave ! ! !

challenge_19_start_file.yxmd
Reply
0 Likes
Jonathan-Sherman
15 - Aurora
15 - Aurora
‎03-12-2019 12:10 PM

Challenge 19 is done!

Spoiler
challenge 19 JMS solution.PNG
challenge_19_JMS_solution.yxmd
Reply
0 Likes
mambo
7 - Meteor
‎03-16-2019 02:19 AM

Here is my solution - I have a feeling that it could be more simply solved..

challenge_19_mambo_solution.yxmd
Reply
0 Likes