Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!

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