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

KORKIS3
8 - Asteroid
‎12-21-2022 11:31 AM
Spoiler
KORKIS3_0-1671651052670.png

Simple Macro solution : )

Reply
0 Likes
spingili
8 - Asteroid
‎12-21-2022 02:31 PM
Spoiler
spingili_0-1671661878542.png

 

challenge_19_solution.yxmd
Reply
0 Likes
StanleyKinnok_Chan
8 - Asteroid
‎12-22-2022 02:18 AM

Here is my solution

challenge_19_solution_StanleyKN_Chan.yxzp
Reply
0 Likes
boglarkalipka
8 - Asteroid
‎12-29-2022 01:52 AM

solved

challenge_19_start_file_solved.yxmd
Reply
0 Likes
danblythe
8 - Asteroid
‎12-31-2022 01:26 AM
Spoiler
Done :)
challenge_19_attempt.yxzp
Reply
0 Likes
mkreddy
7 - Meteor
‎01-01-2023 10:57 AM

firstly i added the row numbers by multi row and then added nill to remaining values and finally grouped by file name

mkreddy_0-1672599577410.png

 

 

challenge_19_solution.yxmd
Reply
0 Likes
lhalliwell
8 - Asteroid
‎01-03-2023 02:18 AM
Spoiler
Screenshot 2023-01-03 101757.jpg

 

Reply
0 Likes
psk009
8 - Asteroid
‎01-03-2023 05:55 AM

#19: Nice exercise

 

psk009_0-1672754001864.png

 

challenge_19_start_file.yxmd
Reply
0 Likes
olga_strubbe
11 - Bolide
‎01-03-2023 06:53 AM
Spoiler
olga_strubbe_0-1672757576818.png

 

Reply
0 Likes
olga_strubbe
11 - Bolide
‎01-03-2023 06:56 AM

I leveraged estherb47 solution, thank you, Esther!

Reply
0 Likes
Live Weekly Challenge