ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests Early 2026. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions. Learn more here
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

mikeprice17
8 - Asteroid
‎01-23-2020 09:38 AM

My Solution

challenge_19_MySolution_File.yxmd
Reply
0 Likes
terry10
12 - Quasar
‎01-24-2020 08:28 PM

Until I did this challenge, I didn't realize that the functionality to input a range from an Excel worksheet has been removed.  - terry10

https://community.alteryx.com/t5/Alteryx-Designer-Ideas/Input-Tool-2018-1-Excel-Range-Feature-Remove...

 

Spoiler
 

 

challenge_19_terry10.yxmd
Reply
0 Likes
AndrewBanh
9 - Comet
‎01-25-2020 02:07 AM

Finished Challenge 19 🙂

challenge_19_completed.yxmd
Reply
0 Likes
ChuyVBabs
8 - Asteroid
‎01-26-2020 10:31 AM

Looked through solutions on first page, didn't see this - think it works:

Spoiler
Besides the multi-Excel input styling:  Sample, Sample, Join (&rename within)
challenge_19_CVBsol.yxmd
Reply
0 Likes
dholle1958A
7 - Meteor
‎01-27-2020 07:41 AM

Solved and submitted

challenge_19_solved_DBH.yxmd
Reply
0 Likes
Original_Yodies
8 - Asteroid
‎01-27-2020 04:24 PM
Spoiler
Original_Yodies_0-1580171011471.png

Interested to see some of the other solutions, then on to the next.

 

challenge_19_Yodies.yxmd
Reply
0 Likes
sonyakasenkramer
8 - Asteroid
‎01-30-2020 06:19 AM
Spoiler
sonyakasenkramer_0-1580393974177.png
Reply
0 Likes
CallieYuan
8 - Asteroid
‎02-01-2020 05:10 PM
 
challenge_19_Get file name and select specific cells.yxmd
Reply
0 Likes
AryCardoso
8 - Asteroid
‎02-02-2020 01:05 PM
 
challenge_19_start_file_Ary.yxmd
Reply
0 Likes
Simonvm9114
8 - Asteroid
‎02-04-2020 02:27 AM

Here's my solution, a bit of detour compared to the solution, but still very educative 🙂

challenge_19_solved_Simonvm9114.yxmd
Reply
0 Likes