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