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

JackBurnham
8 - Asteroid
‎07-01-2021 03:00 AM

b

challenge_19.yxmd
Reply
j_trefethen
8 - Asteroid
‎07-01-2021 02:19 PM
Spoiler
Challenge 19 - JT solution.jpg

 

Not as simple as the provided solution!

challenge_19 - JT solution.yxmd
Reply
jjrbondoc
8 - Asteroid
‎07-05-2021 07:23 AM
Spoiler
jjrbondoc_0-1625494971754.png

 

challenge_19_jjb.yxmd
Reply
nravik
11 - Bolide
‎07-19-2021 12:08 AM

This was fun, thank you.

 

Spoiler
Spoiler!Wk #19.PNG
challenge_19_Sol.yxmd
Reply
Jotigautam
10 - Fireball
‎07-20-2021 02:01 AM

My Solution:

challenge_19_start_file.yxmd
Reply
Elias_Nordlinder
11 - Bolide
‎07-20-2021 03:46 AM

My solution:

Spoiler
Elias_Nordlinder_0-1626777992693.png

 

Weekly_Challenge_19_EN.yxmd
Reply
aravind_sk
8 - Asteroid
‎07-20-2021 09:59 PM

Not the optimal flow, but it works.

 

Spoiler
aravind_sk_1-1626843546312.png

 

challenge_19_aravind_solution.yxmd
Reply
johnyli168
Alteryx
Alteryx
‎07-21-2021 04:39 AM

Solution attached

challenge_19_JL.yxmd
Reply
BenFr
Alteryx
Alteryx
‎07-23-2021 01:55 AM

Imagine my solution could be more efficient, looking forward to looking through others!

Spoiler
BenF2_0-1627030550093.png

 

challenge_19_DONE.yxmd
Reply
dfurlow
8 - Asteroid
‎07-24-2021 09:24 AM

slightly confused by the row numbers... wasn't sure if it meant 2nd row of the worksheet or 2nd row of the data...

challenge_19_df solution.yxmd
Reply
0 Likes