community Alteryx IO Mission Control
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
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