Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask here!
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