Missed the Q4 Fall Release Product Update? Watch the on-demand webinar for more info on the latest in Designer 24.2, Auto Insights Magic Reports, and more!

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

nini
Asteroid

My solution

Aidan_K
Bolide

 

It has been a while since my last challenge ..... its good to be back :)

 

Here is my solution

thanks

Aidan

PhilBalderson
Asteroid

All done.

PhilBalderson
Asteroid

I like these easy tasks, because I always learn something! 

KeithTroutt
Asteroid

solution

jdunkerley79
ACE Emeritus
ACE Emeritus

Made this one more complicated than it needed to be...

 

Spoiler
2019-01-18_22-40-06.jpg
Verakso
Bolide

Must admit that I have skipped a few challenges, but the prior ones was still to turf for me at my current level, so this was nice and basic

Spoiler

So the obvious trick was to use a wildcard while reading in all the *.xls files.

I am just happy that we was not supposed to read in the other sheets, since there seems to be some major differences between .xls and .xlsx files, 

So this was my weekly challenge #30

 

Br
/Thomas 

Suzu
Comet

Here is my solution.

TharunReddy
Asteroid

2019-01-25 (4).png

rfergus
Asteroid

Added some extra steps so I could reuse this later by having an input text with row and column names.

 

Spoiler
image.png