community Alteryx IO Alteryx.com
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

LukasJennings
8 - Asteroid
‎09-10-2020 10:16 AM
Spoiler
Weekly Challenge 19 Solved.jpg

 

Weekly Challenge #19 Solved.yxmd
Reply
0 Likes
david14
8 - Asteroid
‎09-11-2020 06:19 AM

Solution attached.

 

David

26 KB
26 KB
challenge_19_david14.yxmd
Reply
0 Likes
Tony_Castillo
9 - Comet
‎09-12-2020 08:59 AM

 

Spoiler
TC_bot_0-1599926270804.png

A little different than the posted solution but still does the trick

challenge_19_solution_TC.yxmd
Reply
0 Likes
Tokimatsu
12 - Quasar
‎09-17-2020 02:46 AM

Solved.

Spoiler
2020-09-17_18h45_51.png

 

challenge_19_toki.yxmd
Reply
0 Likes
JasonHu
8 - Asteroid
‎09-19-2020 12:47 PM

 

Spoiler
workflow.png

 

 

challenge_19_my_solution.yxmd
Reply
0 Likes
Qiu
20 - Arcturus
20 - Arcturus
‎09-20-2020 06:16 AM

Quite brutal way

Spoiler
en-19.PNG
challenge_19_start_file-Qiu.yxmd
Reply
0 Likes
alexnajm
16 - Nebula
16 - Nebula
‎09-25-2020 11:27 AM

Done! 

challenge_19_start_file_Alex Abi-Najm.yxmd
Reply
0 Likes
DataNexus
7 - Meteor
‎09-27-2020 04:44 AM

I did something very different to all the solutions I looked at. I brought in each via via 2 different inputs then joined them together using the file name.

challenge_19_solution_Joel.yxmd
Reply
0 Likes
simbert
8 - Asteroid
‎09-29-2020 04:50 AM

Sample tool galore!

Spoiler
simbert_0-1601380173609.png

 

challenge_19_done.yxmd
Reply
0 Likes
bjkay30
8 - Asteroid
‎09-29-2020 10:57 AM

Pretty straightforward.  I used a few more tools than most but gets to the same result.

 

Spoiler
bjkay30_0-1601402210637.png

 

challenge_19_solution-BK.yxmd
Reply
0 Likes
curated machine learning resources