In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities here
ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests after December 31, 2025. Set up your security questions now so you can recover your account anytime, just log out and back in to get started. Learn more 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

RichardW
6 - Meteoroid

Couple of different ways to do this

Uploaded a solution for the challenge

pkkmr25
5 - Atom

Solution to challenge#19

JoshuaB
Alteryx
Alteryx

Updated from my old profile

Joshua Burkhow | Chief Evangelist @ Alteryx | Follow me on LinkedIn and Twitter
gautiergodard
13 - Pulsar

solution

Heinrich_Preuß
8 - Asteroid
Spoiler
Heinrich_Preu_0-1665046813207.png

 

geoff_zath
Alteryx
Alteryx
Spoiler

geoff_zath_0-1666112842840.png

 

keynguyen
8 - Asteroid
Spoiler
SpoilerChallenge 19 sol.png

AndrewHoData
8 - Asteroid

For a "Beginner" level challenge, this was surprisingly challenging for me! Great brush up on the wildcard input and use of transformations

 

Image of the workflow below:

Spoiler
AndrewHoData_2-1666234922452.png

 

 

Kinga
8 - Asteroid

Hi,

 

Please find my solution below

 

Spoiler
First I made solution with macro, then I realized how to change it to be non macro :)

Kinga_0-1666261338975.pngKinga_1-1666261392553.png