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_B
Alteryx
Alteryx

This was a very helpful challenge

Erin
9 - Comet

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
18 - Pollux

my solution...