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

My Solution

terry10
11 - Bolide

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
 

 

AndrewBanh
9 - Comet

Finished Challenge 19 🙂

ChuyVBabs
8 - Asteroid

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)
dholle1958A
7 - Meteor

Solved and submitted

Original_Yodies
8 - Asteroid
Spoiler
Original_Yodies_0-1580171011471.png

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

 

sonyakasenkramer
8 - Asteroid
Spoiler
sonyakasenkramer_0-1580393974177.png
CallieYuan
8 - Asteroid
 
AryCardoso
8 - Asteroid
 
Simonvm9114
8 - Asteroid

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