Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
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

Anmol97
8 - Asteroid
‎09-06-2021 12:21 AM

Here's my solution.

challenge_19_start_file.yxmd
Reply
0 Likes
brandowd
8 - Asteroid
‎09-08-2021 12:28 AM

Hi @GeneR,

 

I got the same answer but I prefer the method used in the solution as seemed a bit simpler than mine.

 

Spoiler
brandowd_0-1631086055926.png

 

challenge_19_solution_wd.yxmd
Reply
0 Likes
msalem
7 - Meteor
‎09-14-2021 03:51 AM

My solution

challenge_19_start_file.yxmd
Reply
0 Likes
simon_inviso
8 - Asteroid
‎09-14-2021 05:50 AM

My solution (Spoiler)

challenge_19_start_file.yxmd
Reply
0 Likes
Harrylosborne
8 - Asteroid
‎09-17-2021 03:21 AM
Spoiler
Harrylosborne_0-1631874115962.png

 

Reply
0 Likes
TimN
13 - Pulsar
‎09-22-2021 03:09 PM
Spoiler
TimN_0-1632348542004.png

 

challenge_19_Tim.yxmd
Reply
0 Likes
pfaigmani
7 - Meteor
‎09-25-2021 11:06 PM

My solution to challenge #19

challenge_19_start_file_solution.yxmd
Reply
0 Likes
MichelleL
Alteryx
Alteryx
‎09-28-2021 08:51 AM

Interesting how different the solutions can be . . .

challenge_19_ML solution.zip
Reply
0 Likes
RS452
7 - Meteor
‎10-04-2021 04:13 AM

Good use of Multirow formula.

challenge_19_start_file.yxmd
Reply
0 Likes
AndrewSu
Alteryx Alumni (Retired)
‎10-07-2021 05:49 PM

my take 🙂

challenge_19_SOLVED.yxzp
Reply
0 Likes
Live Weekly Challenge