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

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