Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
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

Ozzy_Campos
8 - Asteroid

Ahhh, I should have used Summarize instead of dual filters and a join.

Ozzy_Campos
8 - Asteroid

Challenge Complete.  I used two filters and a join at the end when I should have just used Summarize.  

Syfer889
7 - Meteor

I have to admit, I was pretty lost on this one. Any insight as to where I might be able to see walk throughs on the file naming in the beginning of challenge for .xls?

CHarrison
8 - Asteroid

Short & simple :) 

Elena_Caric
8 - Asteroid

Fun challenge, thanks!

Elena_Caric
8 - Asteroid

Fun challenge, thanks!

maxjohnson02
8 - Asteroid

This "simple" challenge really threw me off, but I finally got there

OllieClarke
15 - Aurora
15 - Aurora

faffed about for quite some time remembering how to get the record ID to restart, but got there in the end :)

kelly_gilbert
13 - Pulsar
Spoiler
I used a different approach, by retrieving the specific cells in the input SQL statement.
adamp
7 - Meteor
Spoiler
Alteryx19.png