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

ivoller
12 - Quasar

Fewer tools with another approach - Not convinced it's an improvement over previous solutions but gave me an opportunity to play with changing Excel input.

 

Spoiler
Used SQL to union the required data on input, then a simple crosstab to get the output.

2018-04-09_12-11-13.png
jsdeter
8 - Asteroid

Posting SOlution

Oliver
6 - Meteoroid

Solution attached.

mascarenhas_lucas
8 - Asteroid

challenge_19.PNG

 

Spoiler
 
JDelgado
8 - Asteroid

Jet DB query syntax for querying Excel sheets is not intuitive!

 

 

daniel_ferreira
8 - Asteroid

Follow my solution file attached...

KOBoyle
11 - Bolide

Solution attached.

DriveMyData
7 - Meteor
Spoiler
Capture.PNG
StevenBetts
8 - Asteroid

Here's my solution :)

 

 

 

Spoiler
Challenge 19 screenshot.jpg

 

ponraj
13 - Pulsar

Uploading my solution.

 

Workflow.PNGResults.PNG