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

Ioana_Radoveneanu
8 - Asteroid

solved

 

Spoiler
19.png
DataKyle
8 - Asteroid

This was an interesting challenge. I don't usually have to work with excel sheets this much so it was a great thought exercise.

rslopez2
8 - Asteroid

Very similar approach to the previous examples but after looking through other solutions I could have used a few less tools! 

 

Spoiler
RL_Challenge_19.png
MartinStraech
8 - Asteroid

Interesting challenge, and very useful for large input batch.

 

Spoiler
SolutionClipping.PNG
DavidW
Alteryx Alumni (Retired)
Spoiler
Screenshot.png
David Wilcox
Senior Software Engineer
Alteryx
rcor
8 - Asteroid
Spoiler
WorkflowWorkflowMacroMacro
ocasey
6 - Meteoroid

Here is my solution.

PaulN
Alteryx Alumni (Retired)
 
Cumminsj2
7 - Meteor
 
JamesMA
Alteryx Alumni (Retired)

Took me longer than expected, I missed the data in first row detail and so kept getting incorrect answers.

 

Spoiler
Week 19.PNG