We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.

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

JesterOne
7 - Meteor

My solution with Directory Tool + Dynamic Input

 

Spoiler
JesterOne_0-1618837737084.png

 

Maskell_Rascal
13 - Pulsar

Here is my solution!

 

Spoiler
Maskell_Rascal_0-1618942574062.png

 

Cheers!

Phil

realdaniel1989
8 - Asteroid
Spoiler
realdaniel1989_0-1619176505670.png

 

maicolpolvere
6 - Meteoroid

Thank you for the Challenge! Very Interesting! Here my solution with some comments.

 

Maicol Polvere - Sprint Reply Srl

ENix
8 - Asteroid
Spoiler

ENix_0-1620658144630.png

 

jtoboyle
6 - Meteoroid
Spoiler
jtoboyle_0-1620798690297.png

 

Here is my solution for Challenge 19.

Thomas_W
8 - Asteroid

This was a very helpful challenge

Erin
11 - Bolide

I wish I had seen and attempted this challenge 2 years ago! In my last role, we would often pull the latest saved file from a specific file folder using combo of the directory tool, sorts, filters, records IDs and dynamic input. But that was always inputting a single file. I rarely needed to input a whole bunch of identical files, and once did it manually because I'm a sucker. Glad those days are over! 

 

Spoiler
Also, being stubborn, I tried to create the row with record ID as I haven't fallen in love with the multi-row formula tool that seems to be in every challenge. Guess what, didn't work for the additional files. So I used the all time fav multi-row formula tool after all. I learn by doing so these challenges are great for me! 
challenge 19.PNG

RashedDS
8 - Asteroid

My Solution

 

apathetichell
20 - Arcturus

my solution...