Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
Announcement | We'll be doing maintenance between 2-3 hours, which may impact your experience. Thanks for your patience as we work on improving the community!
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

mickael_gest
8 - Asteroid
‎05-22-2018 06:21 AM

My solution:)

challenge_19_start_file.yxmd
Reply
0 Likes
ABarber
7 - Meteor
‎05-25-2018 11:43 AM
 
challenge_19_Solution.yxmd
Reply
0 Likes
STate
7 - Meteor
‎06-01-2018 11:50 AM

It makes me nervous when someone calls a challenge easy, I worry that I'm overcomplicating it if I use more than one tool lol

challenge_19_start_file_STate.yxmd
Reply
0 Likes
Gauthier_B
8 - Asteroid
‎06-04-2018 08:52 AM
Spoiler
Spoiler Challenge 19.PNG
challenge_19_start_file.yxmd
Reply
PrivateStorm
8 - Asteroid
‎06-04-2018 01:43 PM

My solution is attached.

challenge_19_start_file FINISHED.yxmd
Reply
0 Likes
bdaniels
8 - Asteroid
‎06-04-2018 04:52 PM
 
challenge_19_start_file.yxmd
Reply
0 Likes
Ukashi
8 - Asteroid
‎06-06-2018 01:54 AM

Thank you for nice and fun chellenge, It seems that i took slightly different route than in official solution :)

 

Spoiler
image.png
challenge_19_ukashi solution.yxmd
Reply
0 Likes
arein0
8 - Asteroid
‎06-13-2018 07:54 AM
 
challenge_19_start_file.yxmd
Reply
0 Likes
klippard001
6 - Meteoroid
‎06-14-2018 12:35 PM

Here's my answer!

KL_challenge_19_start_file.yxmd
Reply
0 Likes
CaraI
Alteryx
Alteryx
‎06-15-2018 08:22 AM

I decided to do this one via a Batch Macro, even though it wasn't necessary.

 

Spoiler
Spoiler - 
19 workflow.jpg19 Macro.jpg
Challenges_14_Macro.yxmc
Challenges_19_Macro.yxmc
Reply