Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start 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

Dhrish
8 - Asteroid

Solution

Arran_S
8 - Asteroid

Attached

Endeavour
9 - Comet

Hi all,

 

Here is my solution.

Spoiler
Challenge_19.png

Thank you

vinspad
7 - Meteor

Mine is a bit longer cuz I added a Regex to add a column. And I always add a sort at the beginning just to be sure.

erica_sch
7 - Meteor
Spoiler
SPOILER
JessicaEP
8 - Asteroid

Complete

AlteryxUser1
8 - Asteroid
Spoiler
AlteryxUser1_0-1758559263031.png

 

jrlindem
11 - Bolide

Another challenge that showcases how to do things in a less? traditional way.  For whatever the reason my machine would not play nice with the .xls file formats so I had to resave them as .xlsx but the concept is still the same.  A fun one to solve!

Spoiler
jrlindem_0-1758840157945.png